Forum Discussion

bilingual's avatar
bilingual
Helper V
2 years ago
Solved

Top 3 Minimum and Top 3Maximum values, how?

Hi i am used to dynamic filter in Excel, but if i want to create a matrix table with the following values( Price per unit) based on the filter:   TOP 3 Maximum price per unit   TOP 3 Minimum pric...
Need Help
  • ChiragGarg2512's avatar
    ChiragGarg2512
    2 years ago

    bilingual , need to create 2 different matrix visual for top 3 and bottom 3 as only one top N filter can be applied to a visual at a time.

bilingual's avatar
bilingual
Helper V
2 years ago

Thanks a lot, couldn find it, if i want to create a filter, with TOP and BOTTOM 3 bottom, can you help me? - The values are based on a measure.

ChiragGarg2512's avatar
ChiragGarg2512
Solution Sage
2 years ago

bilingual Go to View Tab, there is an option for filters. Then in the filter pane click on the field which has to sorted for top 3 or bottom 3. Expand it and change Filter type to TOP N, select either top or Bottom and the number, also the value on which top/bottom N is being ranked.