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

[Roseus]

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!

 

[Roseus]

*Bump*

 

[Roseus]

Day 2 bump

 

[stoliosoda]

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!