so Dif along... is August - July. I figured that out. topx is the rank(dif) down the client code description. Now I want to filter out only the rows where topx <= 10. How do I do that. For what it's worth, this is also very difficult to do in DAX.
By the way, you can't just put topx in to the filter directly because then there will be no data for July since the July data has to topx value at all.
Hi Morton,
Rather than adding a condition to a dimension filter, you could make a calculated field that says:
[topx] <= 10
And then add that calculated field to the filter shelf. The one thing to watch out for is that the calculation on the Filters shelf is computing the table functions in the same way.
Hope that helps!
Become a Viz Whiz on the Forums! Support the Community and master Tableau.