is there any smart way of preventing QV of calculating an expression multiple times?
I am calculation a value like
sum(<complex set expression> field)
In my pivot table, I need this value multiple times, in the same and in different expressions.
(e.g. if (sum(A)>0, sum(A)*10, sum(A)*-20))
How can I make QV to calculate sum(A) only once?
In a straight table, I would use a (hidden) expression to calculate the value, and reference that column multiple times.
How to do that in a pivot?
Will a variable do the job? Or is that just text replacement, thus doing the calculation multiple times again?
Thanks for any info,