2 Replies Latest reply: Oct 22, 2012 4:10 PM by whiteline _ RSS

    Dimension in pivot table

    steve peroni

      Dear all,

      I'm wondering if it is possible to use a calculated dimension into pivot table in the following way

       

      Pivot tabel

       

      Customer     TOTAL SALES          % of TOTALSALES

      A                    1000                                   10%

      B                    2000                                   20%

      C                    5000                                   50%

      ...

       

      The table above has two dimensions: Customer and TOTAL SALES  (aggr (sum(Sales), Customer)

      How can I calculate the espressione % of TOTALE SALES ? Is it possible to use the dimension TOTAL SALES ?

      I'm a bit confused.

      Thanks in advance