Sorting In a Pivot Table OBI

MarkS

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

 

Sachin Sirohi

Hi,

Do you see the option to sort like shown in attached ? I see that in my pivots in OBI.

Thanks,

Sachin

MarkS

I do, but I think the way my calculation is set up, it is not sorting correctly.