Hi all,

I have created a pivot table that has item numbers down the left as Row Labels and store format across the top as Column Labels (A, B, C) with the values being sales.
I can sort the data by item number and by Grand Total (all formats combined) but I can't sort by individual format (ie Store Format A highest to lowest).
I'm absolutely sure I have been able to do this previously (maybe I'm just giddy for the weekend).
Any help would be greatly appreciated.

Thanks, Feastie.