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

    % of Total in column Pivot-table

    Torunn Midtsjo

      Hi!

       

      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

      Torunn