COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Joker on 12 Sep 2014 05:52:07 AM

Title: Summarise Percentage column in List
Post by: Joker on 12 Sep 2014 05:52:07 AM
Hello,

In my list report there is a groupped column and there is a percentage column. There are other columns also which I am able to summarize using total.
How should I summarise the percentage column for each group in the groupped column?I tried using Calculated and Automatic summary but I did not get Correct results.
I want to calculate the sumarized percentage based on the two highlighted values(columns) in the attachment.
Please help me with this.
Title: Re: Summarise Percentage column in List
Post by: sunny bachan prasad on 12 Sep 2014 10:54:41 PM
Hi Joker
Take calculated data item for percentage and set the aggregation properties as calculated .Set the aggregation properties as Total for the data item which you are using to calculate percentage.
Let me know if you get the correct answer.

Sunny