2 Replies Latest reply on Aug 3, 2017 2:52 AM by Prasanna M

    Sorting Column' Grand Total in Pivot Table

    Prasanna M

      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.