Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jamesqi on 24 Apr 2008 04:31:58 PM

Title: Solve Order not working with Crosstab After adding a filter
Post by: jamesqi on 24 Apr 2008 04:31:58 PM
I created a crosstab report.
1.drag years as first column.
2.drag [actual sales] and [budget sales] measures.
3.created a calculated column [Act vs Budget%].
4.add total to this report.
The total for [Act vs Budget%] was wrong. So I changed solve order of [Act vs Budget%] to 10. Now the report showed correct total.
But when I add a filter to this report, for example, [Actual sales]<>0, then the total is wrong again.
Any idea?

Thanks in advance.
Title: Re: Solve Order not working with Crosstab After adding a filter
Post by: blom0344 on 25 Apr 2008 05:14:45 AM
Totalling percentages is very tricky, as percentages are semi-additive.
The best way to calculate the overall percentage would be something like:

Code Select

total([Act] for report)/total([budget sales] for report)


The use of a detailfilter on a filter on the aggregated set might have some influence too
Title: Re: Solve Order not working with Crosstab After adding a filter
Post by: jamesqi on 25 Apr 2008 12:05:20 PM
The total of Act, total of Budget and total of % use the same formula total(currentMeasure within detail [Product Line]). How can we assign this formula only to calculating total of %.
Title: Re: Solve Order not working with Crosstab After adding a filter
Post by: blom0344 on 25 Apr 2008 02:26:10 PM
Are you working with Reportnet?
Text only | Text with Images