Sorting Column' Grand Total in Pivot Table — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Sorting Column' Grand Total in Pivot Table

Received Response
11
Views
2
Comments
Prasanna M
Prasanna M Rank 4 - Community Specialist
edited Aug 13, 2024 5:57PM in Oracle Analytics Cloud and Server

I have designed a pivot table which shows customer's balances by their products and towards the end, I show the total balances of their accounts. Now, I need to sort the results in descending and filter top 100 customers.

I couldnt find an option to do so. Can someone please guide me on how to achieve the same.

Pivot_Table_Sorting_Subtotal.jpg

Although, I could see an option to 'Keep top X', on clicking that, I am not getting further options to filter out.

Pivot_Table_Sorting_Subtotal1.jpg

Thank you in advance.

Answers

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    why cant you filter it in criteria?

    Rank(Sum(yourmeasure)) <=100?

  • Prasanna M
    Prasanna M Rank 4 - Community Specialist

    I want to order by Sub Total column , DEPOSITS Total, which is not a measure. I dont have an option to filter on it as it is not available in the criteria...