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?

       

      Mike