Huge problem ... likely very hard to solve

[#1]

I have a very big problem and I really cannot solve it. Actually is difficoult to explain as well

I have got a Pivot table. The rows are calculated with a certain expression. For this reason for making the total I have to use aggr... and it works fine. Without that the total is wrong.

But this time I don't need the total but the same calculated expression used for the previous rows.

I would like to have as total in the Calculated column : 100-((100*totalA)/TotalB) ...that is the same expression used for the calculated rows.

I haven't got any ideas. Through the aggr function I can count, sum, avg and so on ....

If somebody can give me just a direction how to solve this problem it will be great.

Thanks

[#2 · Accepted solution]

Ho risolto

I have solved the problem ....

thanks anyway

[#3]

Take Straight table goto Expressions Tab in that there is a Total mode option choose Expression Total mode.