Select months below

[danosoft]

If I select a month I want the information to be shown in the graph as if I had selected all the months below. Example if I select 5 I want the graph to show me the values ​​as if I had selected 1,2,3,4,5. I put the sample photos

This is field :  mese_competenza

this is expression: Sum(CONSUMO_SMC) / Sum({1<ANNO=P(ANNO),DES_REFERENTE=P(DES_REFERENTE)>}BUD_VOLUMI)

how can I put the data in the expression as if I had selected all the months: 1,2,3,4,5 and not just the selected month?

[Mark_Little]

Hi,

Hard to advise fully as there are too many knowns. But the general appraoch i would use would be ad follows.

Create a variable to capture the selections - Var1

GetFieldSelections(Dimension)

Then add the following to the Set Analysis

Month={"<=$(Var1)"}