4 Replies Latest reply: Feb 10, 2013 4:16 PM by Torunn Midtsjo RSS

    % of Total in column Pivot-table

    Torunn Midtsjo



      I hope someone can help me with an expression to calcuate sum of total in % in a pivot-table.


      I have a pivot table with 2 dimensions:

      Dimension 1: Customer

      Dimension 2: Status

      Expression 1: COUNT(Status)

      Expression 2 ?  (here I want an expression that shows the total of Status per customer as a % of all Status)


      The attached excel-file is showing what I want as a result.  I have no problem with showing the total  number of status per customer, but I am not able to show it in percent too.  I suppose I need an expression for this %.


      I guess the solution is simple, but I have problem with finding thit.e correct solution.


      Best regards