Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)"}