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.
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
Hi...can I know which version of reportnet u r using
I am using Cognos 8 now, ver 8.1.2.