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:
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
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
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
thank you
ASKER
thanks