Have spent some time Chinese engineering a pivot table.
Finally got it to format the audience is used to seeing it
except for one sort.
In Chris_report_c the fourth column marked 'Total'
displays the IRFR (incremental rate from revenue)
from smallest to largest.
Allens_report does not sort the totals.
Tried just a straight up Sort Z to A but Excel complains
that it cannot sort because the data is in a pivot table.
So the Total columns is right-clicked and Value Field
Setting is chosen and at the Show Values As tab
In the Show Values As dropdown the Rank Smallest to Largest
option is chosen but this returns '##'.
Have tried a dozen other combinations and screen printed
all eight or so dialogue boxes to try and find the setting
that will sort the column. No luck.
Can someone show me how to get that column to sort?
Allen in Dallas
PS Have attached a copy of the file in case an empirical approach is preferred.