This content has been marked as final. Show 2 replies
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.
|Prouduct||Sum(Sales)||% of Whole Sales|