Sort pivot by column in VALUES AREA, TOP TO BOTTOM (not left to right)

[Bengo]

Hi all,

There are 4 areas in a pivot table, the one on the bottom right called the VALUES AREA, is where it sums (or other calculations)

I have two columns in that field - sum of QTY, and sum of Revenue

All I would like to do is, within each Category Subtotal (defined by groupd in the Row Labels area), to sort the results based on the Sum of QTY column

However as sum of Revenue is greater than the numbers in Sum of QTY, and you only seem to able to sort "left to right" (as opposed to "top to bottom" when sorting by Row Label items), this sorts the data incorrectly

Has anyone got around this?

Thanks

 

[Bengo]

Anyone have an idea? Been searchingever since but can't get around it!

thanks