How do I Sort a Pivot Table that Uses a Slicer to Update Values?

I have two pivot tables that are controlled by a slicer. Each time the user selects a record from the slicer, the pivot tables update. The problem is that the pivot tables are filtered to show to top 10 values, and each time the user selects a record, the values are rearranged and go out of order. I need the records in the pivot tables to order themselves by rank. Note: The second pivot table is not shown in the attached screenshot. Thanks.
contributor-dashboard-screenshot.pdf
calyx_terenAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gowflowCommented:
Can you post a sample workbook that have the pivots ?
gowflow
0
calyx_terenAuthor Commented:
0
calyx_terenAuthor Commented:
Here is an example of the workbook.
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

gowflowCommented:
Is this what you want  ? check the file and let me know. If it is what you want I will let you know how I fixed it.
gowflow
Contributor-Dashboard-Dummy-Data.xlsm
0
calyx_terenAuthor Commented:
That's it! What did you do?
0
calyx_terenAuthor Commented:
I just noticed that it's not working consistently. See Your Bottom 10 Files pivottable for Author 3. The files are not in order by Rank,
0
gowflowCommented:
0
calyx_terenAuthor Commented:
That looks right. Were you able to find a dynamic way to have the tables sort by Rank? I know how to sort them manually by dragging and dropping the rows, but that is not what I'm looking for. How did you do it?
0
gowflowCommented:
Well the way I did it (don't know what you mean by Dynamically) is the following:

1) You click on the first pivot in any cell of the Rank column
2) On the Data Menu choose Sort
3) Click on from Largest to Smallest
4) Press ok

Only on the Pivot Bottom you need to select the opposite from Smallest to Largest.

If you are expecting something else let me know.
gowflow
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
calyx_terenAuthor Commented:
That answers my question. Thank you!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.