Then I got this in a table (with a visual filter [Sales Amount Apr]>0)
Sales Amount Apr May
Sales Amount Apr
Sales rank Apr May
Working as expected. Correct right?
However, I need to display top N. That is the reason to introduce the rank measure. If I apply a visual filter Sale Rank Apr May <=2 (EG to display only the top 2), nothing will display. It only works if I change it to Sale Rank Apr May <=5. So something wrong with the rank measure.
What have I done wrong? and how do I achieve my outcome?