2 Replies Latest reply: Sep 23, 2014 3:15 PM by Massimo Grossi RSS

    how can I have a total from a single value of one dimension

    Leonello Brunori

      I need to calculate some rate against a total  from a single value of one dimension,

      but I don't find an appropriate expression;

      for exemple:

      in a pivot table there are any rows for dimensions:

       

      year     tipology         sum        %

      2013     sales           10000

      2013     rmcost          7000      rmcost/sales

      2013     pcost            2000      pcost/sales

      2013     margin          1000      margin/sales

       

      how can i calculate the percentage in expression table?

      i need sum of tipology = 'sales'

       

      thanks

       

      Leonello