COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: lloraine on 19 Nov 2012 05:56:48 PM

Title: List report with percentage under total row
Post by: lloraine on 19 Nov 2012 05:56:48 PM
I have a list report. I have 10 columns and a total column going across. The total column totals each row. I want to total each column on the bottom which seems pretty straight forward. Now, I want to put a percentage row under the total row. How would I do the percentage row? I want to divide each column total by the total of the total column.
Title: Re: List report with percentage under total row
Post by: pricter on 20 Nov 2012 08:10:16 AM
My suggestion is to use a crosstab if this possible.

It would be easier to achieve what you want with a crosstab rather a list