Hi All,
Need some help.
Have a pivot table with the following fields: Value Columns are Sales, Sales Last Year and Variance. Is there a way to sort this pivot by Variance in the Value Field? I've tried Sort by value and didn't work. Highlighting the whold field and sorting (grayed out) and I even tried to put a copy of the variance in the Row and the didn't do anything either. Any suggestions? I need it sorted from Largest to Lowest with out moving to the end of the pivot. Thanks!
<TBODY>
</TBODY>
Need some help.
Have a pivot table with the following fields: Value Columns are Sales, Sales Last Year and Variance. Is there a way to sort this pivot by Variance in the Value Field? I've tried Sort by value and didn't work. Highlighting the whold field and sorting (grayed out) and I even tried to put a copy of the variance in the Row and the didn't do anything either. Any suggestions? I need it sorted from Largest to Lowest with out moving to the end of the pivot. Thanks!
BRAND | GENDER | SALES | SALES LY | VARI |
Converse | Men | 10 | 100 | -90 |
Nike | Men | 75 | 50 | 25 |
Nike | Women | 100 | 50 | 50 |
Puma | Women | 50 | 100 | -50 |
<TBODY>
</TBODY>