2 Replies Latest reply: Oct 28, 2011 5:31 PM by Leonard Short RSS

    % of whole sales.

      Hi:

      Want to create a pivot table with two expressions, one for the total sales by product (first dimension) and the second for the % that this product correspond considerating all the sales of the other products. How can I calculate this second column?

      I have been trying with aggr and with two diferent tables. Im adding my sampe project...

      Thanks in advance.

       

      ProuductSum(Sales)
      % of Whole Sales

      Product A1010%
      Product B2020%
      Product C2020%
      Product D2020%
      Product E3030%