Ha, that was way too easy! Thank you!

"ShaneDevenshire" wrote:

Hi,

Just put your cursor in the data area for the most recent month and click
the Ascending or Descending sort button.

--
Cheers,
Shane Devenshire


"Jenzz22" wrote:

I have a pivot table with my Items in the rows, months in the colums, and my
data is sum of sales. I want to sort by the most recent month. I changed
the sort from using the items to using the Sum of Sales and it re-sorts but I
have no idea what month it is using to sort?