is it possible to have a pivot table sorted by a custom list that is created on refresh of the pivot table? I am working with a rolling 12 months of results from this year and comparing it to the same month from 1 year ago. i want to have the latest month always in front. I have a custom list set up for the Australian financial year (July to June) which works this month. Next month, when i want to see August results first (top row in my pivot table and last position on my graph), July will still be listed first because of my custom list.
so, how do i make that list order change each month?
so, how do i make that list order change each month?