2 Replies Latest reply on Aug 27, 2018 12:37 AM by daniel.braw.1

    Show fixed number of entries above and below selection


      Hi all,


      So I'm trying to build a view which shows ranking development over time (Ranking is a measure, not a table calc or calculated field).


      Since there are up to 200+ Products in the view the line chart I am using gets very crowded. For that reason I want to let my customer choose 1 product, and have the view display the line for that product and the 5 closest products rated higher and lower than the selection.


      So in other words if the selection is Product Z, which has a ranking of 21 (at the latest available date), then the view needs to show Product Z and the products ranked between 16-26. I've illustrated the goal below:


      Can anyone point me in the right direction for making this work?