Display reference lines based on a filter selection

Viewed 10

enter image description here

Right now, there are two reference lines added (which are the blue and red lines) for each cell. The blue line is SUM(1DayLValue) to SUM(1DayUValue) and the red line is SUM(2DayLValue) to SUM(2DayUValue).

I would like the user to be able to select a filter which has options (1 Day and 2 Day). If the user selects 1 Day, only the blue line shows. If the user selects 2 days, only the red line shows.

Right now, the red and blue lines are individual cells in my dataset. And I don't have a column that I can put as a filter where the user can select 1 Day or 2 Day.

How is this done?

0 Answers
Related