1 Reply Latest reply: Oct 2, 2014 4:44 AM by Ruben Marin RSS

    % of Sales in a pivot

      Hi

      I am trying to calculate % of sales using a pivot ,with 2 dimensions ( Regions , Products)

       

      Desired output :


      Region  Product 1  Product 2  Product 3

      America     30%      40%          30%

      Asia           40%       40%          20%

      Europe        60%      10%          30%

       

      However

      If i use sum(Sales) / sum( TOTAL Sales)  , the % is split across the 3*3 and everything adds upto 100%  , which is not the case

      Hence not usefuk

      I want for each row to add to upto 100%

       

      Please help

      thanks