Hi All,
THis is for Excel 2007. I have a piviot with the following fields. I am having trouble trying to sort the piviot by CHg from Highest to lowest $. I tried highlighting the whole column to sort. Just one value in the column to sort. Zilch. The sort option on both brand and gender is set to manual.
Is there a way to do this without moving the columns around? Values are Sales, Sales LY, Chg, Units and Units LY. Thanks!
[TABLE="width: 500"]
<TBODY>[TR]
[TD]Brand[/TD]
[TD]Gender[/TD]
[TD]Sales[/TD]
[TD]Sales LY[/TD]
[TD]Chg[/TD]
[TD]Units[/TD]
[TD]Units LY[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Nike[/TD]
[TD]M[/TD]
[TD]1000[/TD]
[TD]800[/TD]
[TD]+200[/TD]
[TD]10[/TD]
[TD]8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Nike[/TD]
[TD]W[/TD]
[TD]500[/TD]
[TD]800[/TD]
[TD]-300[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rebok[/TD]
[TD]W[/TD]
[TD]250[/TD]
[TD]350[/TD]
[TD]-100[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Adidas[/TD]
[TD]M[/TD]
[TD]500[/TD]
[TD]100[/TD]
[TD]+400[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
THis is for Excel 2007. I have a piviot with the following fields. I am having trouble trying to sort the piviot by CHg from Highest to lowest $. I tried highlighting the whole column to sort. Just one value in the column to sort. Zilch. The sort option on both brand and gender is set to manual.
Is there a way to do this without moving the columns around? Values are Sales, Sales LY, Chg, Units and Units LY. Thanks!
[TABLE="width: 500"]
<TBODY>[TR]
[TD]Brand[/TD]
[TD]Gender[/TD]
[TD]Sales[/TD]
[TD]Sales LY[/TD]
[TD]Chg[/TD]
[TD]Units[/TD]
[TD]Units LY[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Nike[/TD]
[TD]M[/TD]
[TD]1000[/TD]
[TD]800[/TD]
[TD]+200[/TD]
[TD]10[/TD]
[TD]8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Nike[/TD]
[TD]W[/TD]
[TD]500[/TD]
[TD]800[/TD]
[TD]-300[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rebok[/TD]
[TD]W[/TD]
[TD]250[/TD]
[TD]350[/TD]
[TD]-100[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Adidas[/TD]
[TD]M[/TD]
[TD]500[/TD]
[TD]100[/TD]
[TD]+400[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]