This content has been marked as final. Show 2 replies
Hi, I have a pivot table with the following structure (the measure is Total Sales):
|Customer 1||Product A||$ 40,000||$ 3,000|
|Product B||$ 35,000||$ 50,000|
|Product C||$ 70,000||$ 6,700|
|Customer 2||Product A||...||...|
Is there any way to take sort the rows of products according to the sale during the year? Ie take 2016, and to order the items according to the total sold (C, A, B), and then to do the same with 2015 (B, C, A). I can not find how to sort the table according to the measure.