Dar All,

I have a pivot table that contains a list of contacts with the results of 3 × measures, 1 = Turnover, 2 = Profit Contribution, and 3 = Margin %, each of which have been displayed by month, and sub-totalled by accounting period.

When I remove measures 2 & 3 from the table, I am able to sort by any column, however, when I add measures 2 & 3 back in, I am only able to sort by contacts and not the subtotal of say "Turnover".

Help Please!!!!!!!!!

Thank you all.