COGNOiSe.com - The IBM Cognos Community

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.

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