Cumulative measure in Key Value graph, filtered by Drop down list

[Bliss]

Hello,

I'm trying to do the following:

Objects

Drop down list control || assigned variable: Date (format YYQC5)

Key Value graph || assigned variable: either Measure 1 (Cumulative total) OR Measure 2 (CumulativePeriod)

The Drop down list is filtering the Key Value.

When selecting a date in the Drop down list, I'd like the Key Value to return the cumulative total up to the date selected in the Drop down list.

Example:

Data

Quarter  || Amount

Q1 2022 || 100.000

Q2 2022 || 125.000

Q3 2022 || 75.000

Q4 2022 || 100.000

Objective

Selection: Drop-down list = 2nd Quarter 2022

Results: Key Value  = 225.000 (100.000 + 125.000)

Actual Results

Selection: Drop-down list = 2nd Quarter 2022

Results: Key Value = 125.000

How should I proceed?

additional info:

release: 8.5.2

[acordes]

There are several ways to solve this.

If the quarter is defined as "date" then you can use the quarter in a slider as page filter. The key value shows the accumulated value. 

Or assign a parameter to the quarter selection and apply a filter in the key value object.