Solve Order not working with Crosstab After adding a filter

[jamesqi]

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.

[blom0344]

Totalling percentages is very tricky, as percentages are semi-additive.
The best way to calculate the overall percentage would be something like:

Code Select Expand


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

[jamesqi]

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 %.

[blom0344]

Are you working with Reportnet?