Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: cognos3 on 04 Jun 2012 09:53:20 AM

Title: How can i show columns for 'Total' of complaints for current and prior year?
Post by: cognos3 on 04 Jun 2012 09:53:20 AM
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?
Title: Re: How can i show columns for 'Total' of complaints for current and prior year?
Post by: cognos3 on 04 Jun 2012 10:16:16 AM
 
                     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!!!
Title: Re: How can i show columns for 'Total' of complaints for current and prior year?
Post by: wyconian on 18 Jun 2012 11:03:26 AM
Try adding an aggregation from the menu bar (big greek looking E icon)
Text only | Text with Images