If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to add list summary to another list

Started by yvswamy, 05 Apr 2013 03:27:39 AM

Previous topic - Next topic

yvswamy

Hi All,

I am problem to add the Summary of one List to another List individual rows. Please help me.

Sample:

List1:

City                     Rev

Hyderabad          12
Bengalure           18
Chennai              10
TOTAL                 40

List2:

City                   Rev

ABC                   10
AAA                   20
CCC                  30

Required Result:

City                   Rev
ABC                   50 (10+40)
AAA                   60 (20+40)
CCC                   70 (30+40)


Thanks in advance.


RKMI

Hi,

What are you trying to do? Are trying to say list1 cities are detail to the summary list of list 2?  Even if that is the case why would you add a detail breakdown with summary like you are showing in list 3?

I think you need to provide a better example or ask your user you result clearly.

For example:
Product Product line Amt
Nike     |  Shoes      | 40
Nike     |  Apparel    | 30
Nike     |  Other       | 20
PUMA     |  Shoes      | 50
PUMA     |  Apparel    | 40
PUMA     |  Other       | 10

So your summary would be,
Nike   | 70
PUMA | 100

Thanks,
RK