I want Disply Top 3 sales.but it will showing More column But In my Data having same values.
I will Create Filter in Sales and I select top N=3.but it will showing 5 records. How remove duplicates.
Pull Sales twice and change the expression as topN(Sales) and then filter and use value 3 to filer.
With that you'll have columns in criteria like
Prod Sales topN(Sales)
let me know updates, if helps pls mark as correct :)