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

Aggregating percentages calculated from two other columns

Started by dylsing, 15 Oct 2006 11:17:35 PM

Previous topic - Next topic

dylsing

Hi,

I have this particular crosstab reportreport:

                Revenue       Forecast      Percentage accuracy
US            400               500             80%
UK            200               300             66.66%
France      200               400             50%
Summary  800            1200           66.66%

The portion in bold is the aggregated row. I have a issue which I cannot resolve for the "percentage accuracy", I manage to state as a Data Item how this column is calculated which is = "Revenue/forecast" but my summary which is "Total Revenue/Total forecast" is not displayed correctly.

Presently, the system is adding up the column of percentages, how can I have the aggregate cell to calculate the Total Revenue/Total forecast?

I have tried looking at the Rollup Aggregate and Aggregate Functions but can't figure out a way to do it.

Any kind of suggestion is much appreciated. Thank you.

dylsing

Just found out how to do it.

When I click on a Crosstab node member and then click on the aggregate button, I keep selecting the "Total" option, which means the aggregate row adds up all the rows by default.

What I did to correct this was to:
1) Select crosstab node
2) Click on Aggregate button, select "Aggregate option"
3) For the row containing the percentages, leave the properties Aggregate Function and Rollup Aggregate Functions as Automatic

Report Studio would naturally know how to handle the summary of this column. Really simple but for a newbie like me, quite a revelation... hahaha

mrcool

Hi...can I know which version of reportnet u r using

dylsing