Solved

Pivot Table sorting

Posted on 2014-11-17
4
70 Views
Last Modified: 2014-11-17
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 OrderHowever, 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 OrderHere's the best I can do:
Pivot orderOlympics.xlsx
0
Comment
Question by:Frank Freese
  • 2
  • 2
4 Comments
 
LVL 25

Assisted Solution

by:ProfessorJimJam
ProfessorJimJam earned 500 total points
Comment Utility
please find attached.
Olympics.xlsb
0
 
LVL 25

Accepted Solution

by:
ProfessorJimJam earned 500 total points
Comment Utility
what you do in the pivot table is that you need to put the year also in the row label and then sort from small to large and then hide that column of year in pivot.  just like the one i attached.
0
 

Author Comment

by:Frank Freese
Comment Utility
looks good
thanks
0
 

Author Closing Comment

by:Frank Freese
Comment Utility
thank you
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now