Hi John, yes, EXACTLY what I needed, didn't figure it was so simple as I was playing around with RANK calculated fields.
I have also added the top N parameter so you can chose 5, 10, x.
Do you think it's possible to rank top N after the total turnover over the time periods? That would avoid putting a vendor into the Other set that performed great in 2013 but then lost performance in 2015?
So I have come up with a solution to calculate the total by vendor over time (Calculated field with window_sum), but when I want to use this calculated field as basis for Top N in the Set, I cannot select it.
Thanks for any ideas(suggestions)