Pivot Tables - Hide a column from view, but use to sort?

Roseus

Board Regular
Joined
Dec 20, 2010
Messages
87
I'm working on a Quartile Report for a Report Card. I have a Pivot that shows which Quartile everyone falls into for each thing they are graded on.

For example, let's say the following three are in the 1st Quartile for Metric 1:

Einstein - 100% - 1st
Newton - 95% - 1st
Hobbes - 90% - 1st

When I Pivot their Quartile info, and sort it for Metric 1, it doesn't rank it correctly:

Newton - 1st
Einstein - 1st
Hobbes - 1st

I want it to show them in the same order, or by rank.

So I added a RANK formula to the data:

1 - Einstein - 100% - 1st
2 - Newton - 95% - 1st
3 - Hobbes - 90% - 1st

I want to Pivot the RANK, NAME, and QUARTILE data, sort Metric 1 by the RANK, but not have the RANK column visible to users!

Can anyone help me out? Thanks!
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
I would like to bump/echo this request. Very handy thing for creating estimates with PivotTables, which I do all the time...any help most appreciated!
 
Upvote 0

Forum statistics

Threads
1,224,502
Messages
6,179,126
Members
452,890
Latest member
Nikhil Ramesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top