reuse of expression in pivot

[#1]

Hello,

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,

Thilo

[SunilChauhan]

write ur expression in a variable and reuse.

this may help u.