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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Summarise Percentage column in List

Started by Joker, 12 Sep 2014 05:52:07 AM

Previous topic - Next topic

Joker

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.

sunny bachan prasad

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