asked on
Pivot Table sorting
Folks,
Attached is a workbook named Olympics. There are two tabs: One for the data and the second for the pivot table.
Here is what I am trying to get to:
![Pivot Order]()
However, I do not understand in the filtering example below how it is filtered based upon Yr Country but displayed by Year City with the earliest year first?
![Pivot Order]()
Here's the best I can do:
![Pivot order]()
Olympics.xlsx
Attached is a workbook named Olympics. There are two tabs: One for the data and the second for the pivot table.
Here is what I am trying to get to:
However, I do not understand in the filtering example below how it is filtered based upon Yr Country but displayed by Year City with the earliest year first?
Here's the best I can do:
Olympics.xlsx
Microsoft Excel
Last Comment
Frank Freese