1. Go to the Edit mode by clicking on .
2. Select the table we created just now in the preceding recipe.
3. Edit the CaseID dimension, and put in the following calculation:

=if(Match(CaseID, '$(=FirstSortedValue(distinct{<Value={"<=$(=Median({<Value= 
 {'>=$(=fractile(Value, 0))<=$(=Fractile(Value, 0.25))'}>} 
 Value))"}>} CaseID, -Value))', '$(=FirstSortedValue(distinct{<Value={"<=$(=Median({<Value= 
 {'>$(=fractile(Value, 0.25))<=$(=fractile(Value, 
 0.5))'}>} Value))"}>} CaseID, -Value))', '$(=FirstSortedValue(distinct{<Value={"<=$(=Median({<Value= 
 {'>$(=fractile(Value, 0.5))<=$(=fractile(Value, 
 0.75))'}>} Value))"}>} CaseID, -Value))', '$(=FirstSortedValue(distinct{<Value={"<=$(=Median({<Value= 
 {'>$(=fractile(Value, 0.75))<=$(=fractile(Value, 1))'}>} 
 Value))"}>} CaseID, -Value))' ), CaseID, Null() ) 

4. Uncheck Show Null Values for CaseID.

5. The resultant table appear as follows:

6. As you can see, every quartile is now showing only the claim corresponding to the median value in each quartile.