I'm sorry I was very vague in my explanation of what I am looking for. Attached is a picture of the view I currently have/what the client wants. I need to be able to find the lowest 3 values of Ratio out of the top 25 delivered codes. The codes are sorted on Deliveries using the Rank calculation along with a table calc. There has to be a window_min() or running_min() calc that will allow me to find the lowest Ratio numbers out of the top 25 codes that are sorted on Deliveries.
I hope this makes sense.
Lowest Values.JPG 57.4 KB
Not had chance to check out how the calcs could be used.
Could a double filter work? Copy the product code attribute to give two product code dimensions. Do a top 25 filter based on deliveries in one. Do a bottom 3 filter on ratio on the other.
Because the filters are applied at the same time this won't work. But, if you set the first filter to be applied in context, it will run first and the second filter will work fine.
How's the attached? I used three calculated fields:
[Lowest in list?]
I also used parameters so you can control how many of the top n you filter, and how close to the lowest you want to highlight/include.
bottom 3 in list.twbx.zip 113.3 KB