Set Analysis

[#1]

example data:
Period 1 has Value 1500
Period 2 has Value 2500
Period 3 has Value 3500

the following expression:

sum({$<Period = {1,2} >} Value)

gives me the correct result of 4000 as it is selecting only Period = 1 and 2.

I want to be able to select only Period 3 and for this set analysis to give me the result aggregation Period 1, 2 and 3, i.e. 7500.

Therefore I want an expression to look at ALL Values where the Period is less than or equal (<=) to the current selection.

[#2 · Accepted solution]

Hi Peter,

Here you are a possible solution.

Best regards.

[#3]

Or instead of variables, you can use the following expression:

sum({$<Period = {"<=$(#=max(Period))"} >} Value)

BR
Jakob

[#4]

Thank you Jakob.

[#5]

Thank you Miguel