Solved

Pivot Table sorting

Posted on 2014-11-17
4
78 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
ID: 40448021
please find attached.
Olympics.xlsb
0
 
LVL 25

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 40448025
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
ID: 40448093
looks good
thanks
0
 

Author Closing Comment

by:Frank Freese
ID: 40448095
thank you
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

786 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