Categories
Sorting In a Pivot Table OBI

Summary
How to sort on a measure within Pivot Table
Content
I have a measure called, # of Requisitions with Less Then 20 Apps none in BKG. This is by Recruiter. First I created a flag to give me all Requisitions where there are 20 Applications with none in Background Check and then filtered on it. I then created a measure within a pivot table to give me the counts by Recruiter. The system automatically sorted my pivot table by Recruiter in alphabetical order. How do I sort from high to low off of # of Requisitions with Less Then 20 Apps none in Background? I tried creating another variable by Recruiter and did a TOPN. That did not work. Below is a sample of my output.
Thanks,
Mark
Comments
-
Hi,
Do you see the option to sort like shown in attached ? I see that in my pivots in OBI.
Thanks,
Sachin
0 -
I do, but I think the way my calculation is set up, it is not sorting correctly.
0