Calculation in a crosstab 3

[gruposenda]

Hi:
I am using a crosstab where appear 2 data in the rows : Group and Subgroup, and in the columns : Revenue, Budget, Difference (Revenue - Budget) and percentage of difference (Difference /Budget). When I place a total, the 3 first columns are just sums, but the fourth always is Difference / Budget. How can I do to get this calculation insted of a sum ? In a list the option rollup agregate function is changed to calculated, but is there something similar to this ?
Thanks in advance

 

[ranjani06]

You could try giving a higher solve order to that column sum.

 

[gruposenda]

I have the next structure :
|Data1 |Data2 |Data1-Data2|(Data1-Data2)/Data2
Concept 1 | 10 | 8 | 2 | 25%
Concept 2 | 25 | 15 | 10 | 67%
Concept 3 | 9 | 15 | -6 | -40%
|--- | -- | -- | --
Totals(1) | 44 | 38 | 6 | 52% (ERROR)
Totals(2) | 44 | 38 | 6 | 16% (OK)

The result 52% is wrong. The right value is 16%. How can I use this option to get : sum (Data1-Data2)/ sum (Data2) = 16%. ?

Thanks

 

[ranjani06]

Did you give solve order for the last column as say 2? I had the same problem and my datasource was DMR. In the query explorer I changed the solve order of the column to a higher number and got the correct result. Do let me know the result..

R

 

[gruposenda]

It works fine.

Thank you ranjani06.

 

[4812awad]

Did you give solve order for the last column as say 2? I had the same problem and my datasource was DMR. In the query explorer I changed the solve order of the column to a higher number and got the correct result. Do let me know the result..
"


i face same problem what you mean