I want to use a slider to select the last x values. Therefore I used the formula SIZE() - INDEX() < [Values to show]. This should provide me with a ranking that is sorted descending. In the attached workbook you can see the analysis I want to create. Here is the problem that the ranking is created for each product and segment. So setting the slider to 1 will show multiple datapoints. Is it possible to only show 1 value and keep the Marks as they are, so that selecting more values will show different products and segments? E.g. the first point is product A / segment A, the second point product B / Segment B, the third point product C / Segment A and so on.
I don't really understand what you're trying to do here. SIZE() - INDEX() is going to give you an integer value and that value will depend on how you've set up the table calculation. But, are you trying to do a rank instead? Can you explain, in words what you're trying to do?