
1. Re: How do I use RANK_PERCENTILE in a table?
Yuriy Fal Feb 27, 2016 10:35 AM (in response to Josh Craig)Hi Josh,
If you want a table with just two cells,
simply put your [score] green pill on a Label
and choose Measure > Median aggregation.
Then put your [gender] blue pill on a Row or Column.
Hope it helps.
Yours,
Yuri

2. Re: How do I use RANK_PERCENTILE in a table?
Josh Craig Feb 28, 2016 4:25 PM (in response to Yuriy Fal)Hi Yuri
Thanks for the response. That would help me if I just wanted the median score for boys and girls. But what I want requires an extra step. I want the table to show just the rank percentiles of the median score for boys and girls.
Josh

3. Re: How do I use RANK_PERCENTILE in a table?
Bora Beran Feb 28, 2016 10:05 PM (in response to Josh Craig)2 of 2 people found this helpfulAdd the field
MEDIAN([Test Score]) to your view. Click on the pill and select Add table calculation > Percentile
Select Advanced... from Running Along drop down and move Gender to the box for Partitioning.
That should do it.

4. Re: How do I use RANK_PERCENTILE in a table?
Josh Craig Feb 28, 2016 10:26 PM (in response to Bora Beran)Hi Bora
Thanks for your response but that's not quite working. I just get a value of 100 per cent for both genders.
Is there anywhere special I need to put the Gender pill?

5. Re: How do I use RANK_PERCENTILE in a table?
Bora Beran Feb 28, 2016 10:40 PM (in response to Josh Craig)1 of 1 people found this helpfulYou need to have have the dimension that defines the individuals e.g. StudentID into the view and that dimension has to be in the addressing box.

6. Re: How do I use RANK_PERCENTILE in a table?
Josh Craig Feb 28, 2016 10:58 PM (in response to Bora Beran)OK I'm getting close. Where can I put the StudentID pill so it's not shown on the table?
I just tried following your instructons above and putting the StudentID pill in 'Detail' but now the table has a different cell containing the percentile for each studentID.
In other words, it's showing me the percentile of the median score for every student (each student only has one score).

7. Re: How do I use RANK_PERCENTILE in a table?
Bora Beran Feb 28, 2016 11:05 PM (in response to Josh Craig)2 of 2 people found this helpfulMaybe I am not understanding the question. I thought you were trying to get the percentile rank of each student but males among males, female students among females etc. If you don't want a cell for each student, what should the end result show?

8. Re: How do I use RANK_PERCENTILE in a table?
Josh Craig Feb 28, 2016 11:15 PM (in response to Bora Beran)The end result should show two numbers: the percentile for the MEDIAN score of females and the percentile for the MEDIAN score of males.

9. Re: How do I use RANK_PERCENTILE in a table?
Bora Beran Feb 28, 2016 11:20 PM (in response to Josh Craig)2 of 2 people found this helpfulI think I am still misunderstanding the question.
Wouldn't that be 50th percentile given median is the 50th percentile.

10. Re: How do I use RANK_PERCENTILE in a table?
Josh Craig Feb 28, 2016 11:23 PM (in response to Bora Beran)That would be true if I wanted the percentile of all female scores. But i want the percentile of ALL scores.
So if boys perform better than girls then the median score for boys is higher than the median score for girls and the percentiles for each are different when taken from the combined distribution of boys and girls.
Does that make sense?

11. Re: How do I use RANK_PERCENTILE in a table?
Yuriy Fal Feb 28, 2016 11:47 PM (in response to Josh Craig)2 of 2 people found this helpfulHi Josh,
If I understand you would like to get something like this.
Please find the attached wb (version 9.0)
with Sample Superstore as an example.
Hope it could help.
Yours,
Yuri

12. Re: How do I use RANK_PERCENTILE in a table?
Josh Craig Feb 28, 2016 11:49 PM (in response to Yuriy Fal)Hi Yuri. I can't see an attachment.

13. Re: How do I use RANK_PERCENTILE in a table?
Yuriy Fal Feb 28, 2016 11:51 PM (in response to Josh Craig)2 of 2 people found this helpfulHere it is (again).

14. Re: How do I use RANK_PERCENTILE in a table?
Bora Beran Feb 28, 2016 11:54 PM (in response to Josh Craig)2 of 2 people found this helpfulThanks for clarifying.
If you have an odd number of students, median will match an actual value in the table. Assuming that's the case here is how you can do it. I am assuming this because to rank everything all the values have to be in the same column that is both the median for each gender and the actual test scores for all students.
{exclude StudentID : MEDIAN([Test Score])}
would give you the median for each gender. So we will compare each row to see if it matches the median and filter out (hide) the rows that don't match.
To hide the items that don't match, you can write the following calculation and drag it onto filter shelf and just keep 1. Make sure it has Gender in the partitioning box.
RANK_UNIQUE(MAX(IF [Test Score] = {exclude StudentID : MEDIAN([Test Score])} then 1 else 0 end))
This should keep just one value for male and another value for female.
Then do you RANK_PERCENTILE(Median([Test Score]) with both StudentID and [Gender] in Addressing box (as I described in an earlier message) which should do the trick.