2 Replies Latest reply: Oct 2, 2014 12:18 PM by Dafnis X RSS

    Control expression total in pivot table

    Dafnis X



      In a pivot table, I use the following expression to show difference which will be presented in % :

      [Actual Demand]/[Optimal Demand]-1


      But in the Total, it shows the sum of all the differences.

      Is it possible to control this behavior to show the average in the total?