Forum Discussion

Marac0105's avatar
Marac0105
Frequent Visitor
7 years ago
Solved

Top N

Hi all,

 

I have dataset (please see example) and trying to have a matrix which will show Top 10, Top 15, Top 25 customers, depending on slicer selection, ranked by Total amount column. I have an issue due to the fact that I have Other and Total rows, and in matrix Total should be sum of Totals from data set and Other should be variance of Total and sum of Top 10, Top 15, Top 25 (depending of the slicer selection).

Thanks in advance.

 

Tips and Tricks

3 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    7 years ago

    Hi Marac0105 

    To make it dynamic ie Top 10, Top 15 and top 25 it would have to be a Measure.

    To make it display 1, 2, 3 ... 10 and Other it would have to be a Column.

    You can not have both

     

    Regards,
    Mariusz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.