
1. Re: Minimum Rank for a Category
Simon Runc Sep 7, 2018 8:58 AM (in response to Casey Terp)hi Casey,
Tricky one!
So I think you can do it like this...
First I created a RANK formula
[Manufacturer RANK per State]
RANK(SUM([Sales]))
and set it up like this
I then used this formula in another Table Calculation to get the MIN of that RANK (as I've nested a Table Calc in a Table Calc, we get the option to set the compute differently for each)
[Manufacturer RANK per State Min]
WINDOW_MIN([Manufacturer RANK per State])
This part is set up like this
I then brought this onto the filter shelf, and set it to values 110
Finally, and this is more to check it's working...
I created a Table Calc filter for the Manufacturer. As Table Calculation filters are applied last, it means that the RANK function still have access to the data and so can still compute the correct RANK. I like to think of these as filtering the view, but not the underlying data.
Hope that makes a bit of sense...quite a few advanced concepts here.

Rank problem_SR.twbx 427.7 KB


2. Re: Minimum Rank for a Category
Casey Terp Sep 7, 2018 10:04 AM (in response to Simon Runc)Thanks Simon that worked perfectly. I didn't even think of using window_min, I was just trying the regular min function and getting an aggregation error.
Casey