How to count/summarize Cognos LIST grouped columns?

811 Views Asked by At

I have this LIST having the following data items in the following order: DataItemA, DataItemB, DataItemC, DataItemD, DataItemE, DataItemF, DataItemG, DataItemH Groups on :DataItemA, DataItemB, DataItemC, DataItemD

Structure : List Header : using DataItemA List Footer : Using DataItemB, DataItemC and DataItemD

DataItem E : is a metric and is called Metric1 DataItem F : is a metric and is called Metric2

I clicked Metric1 column and clicked on the TOTAL button from the menu and it automatically created TOTALS for each any of the grouped data items(grouped DataItemB, DataItemC and DataItemD)

I the try to the same with the Metric2 but the TOTAL displaying is the same (wrong) for each of the grouped date items. Any ideas ?

Thanks in advance for any valuable feedback!

Data sample Same data sample but better print screen image After clicking on the following menu Metric 1 properties Metric 2 properties

1

There are 1 best solutions below

0
On

Just to let you all know that the reason it wasn't correctly displaying because the some data items needed to come from another query subject the automatic total is now working as expected.

Regards and thanks to all!