1 Reply Latest reply on Jul 4, 2018 11:50 AM by Ken Flerlage

    Use a slider to select the last x values




      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.