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

    Control expression total in pivot table

    Dafnis X

      Hi,

       

      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?

       

      Thanks!