1 Reply Latest reply: Aug 1, 2011 10:44 AM by Sunil Chauhan RSS

    reuse of expression in pivot



      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,