4 Replies Latest reply: Jan 19, 2018 8:20 AM by Mike Slottje RSS

    Sorting dimensions in pivot table

    Mike Slottje

      Hi guys,


      I have a pivot table with the following fields:

      fieldnames between brackets []


      Rows: Months [Month], Customer as [Bill-to-Customer]

      Column: Category [Product Category]

      Measure: Sales, which is sum({<Year={'2017'}>}[Nett Amount new EUR])


      I do have the top 10 customers per category per month, but now I want to sort these customers based on the sales (descending).

      So, the end result should be a pivot where the top 10 customers are shown per category and per month, sorted with the biggest customer on top.


      How should I make this sortation in the set analysis?