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!
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!