5 Replies Latest reply on Jan 9, 2018 4:38 PM by Zhouyi Zhang

    Sorting Measure in a table with multiple dimention

    Roisha Pal

      Hi Team,



      Please find my attached workbook. It has Customer name,Region, Category, sub category in the table. I want to give ability to user to sort top 5 or top 10 customers

      sorted by amount.



      For Example User has selected Central as Region, and top 5 in the parameter he should be able to see only top 5 customer in Central region. Likewise for others. When all region is selected he should  be able to see top 5 customer across all region sorted by amount

      Can please anyone help me?