Forum Discussion
Helper VTop 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 price per unit
Is there an easy way to do so?
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.
3 Replies
ChiragGarg2512Solution Sage
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.
bilingualThanks 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
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.