Sort Pivot Table by Column Subtotal

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.

Some sample data? We do not see your data layout so it will be difficult to help

I have copied a section of the pivot table and pasted into another workbook, the Orange sections are the elements that I want to be able to sort by.

Thank you

Thank you, but please change the data and show data source for PT