How to sort Variance Column from Largest to Lowest in a Pivot Table

[Grimm127]

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!

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>

 

[General Ledger]

I think you should be able to sort by doing the following:
1. Select a cell in the BRAND column.
2. Right click to display a contextual menu.
3. Select Sort.
4. Select More sort options.
5. Select Descending.
6. Select the name of the field on which to sort from the drop down list.

Best of luck,

G/L