Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Sorting In a Pivot Table OBI

53
Views
2
Comments

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

 

Sorting in Pivot Tables.png

Comments

  • Sachin Sirohi
    Sachin Sirohi Rank 2 - Community Beginner

    Hi,

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

    Thanks,

    Sachin

    Untitled.jpg

  • MarkS
    MarkS Rank 4 - Community Specialist

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