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

 

How can i show columns for 'Total' of complaints for current and prior year?

Started by cognos3, 04 Jun 2012 09:53:20 AM

Previous topic - Next topic

cognos3

I have a column chart report having comparion between current year and prior year complaints for different products. How can i show columns  for 'Total' of complaints for current and prior year?

cognos3

 
                     Ann         Lif             MF                    Oth     Total(Line of Business)1
1Q 2011       549             408           23                  18                        598
1Q 2012          987          874             35                40                           936

I am able to show the columns for Ann, Lif, MF and Oth for 2011 and 2012 but not for total, I want to show the  Total   in the column chart? Please help!!!

wyconian

Try adding an aggregation from the menu bar (big greek looking E icon)