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
... View more