- ABM Currency Value (IF([ABM Currency] = 'USD', AVG(CURRENCY_VALUE), 1))
- TOTAL ([ABM Total] * [ABM Currency Value])
(this is just part of the pivot table, of course)
The total from the TOTAL column does not work OK. It is as if it's just taking ABM TOTAL total and multipliying for ABM CURRENCY VALUE total, which, of course, is not what I want. I want the sum of its rows, instead.
I have read about similar issues in this community and about AGGR function and I think the solution has to do with it, but I just can't manage to show the right total.
Could anybody lend me a hand? Thank you very much!