Sum from current year AND selection

[reporting_neu]

Hi,

I have a small problem. I have the KPI SALES for the current year and next to it a diagram with the months of this year as a dimension.

I have used the following formula so far:

Sum({$<$(GUI_CAL_PA_SET(year,0)), Sales.Open = {'0'}> } Sales)

GUI_CAL_PA_SET = Definition of time

This ensures that the current year and not all values ​​are always displayed. But I would like that when a dimension is selected in the diagram, the corresponding value of the month is output.

What do I have to change in the formula so that the selection overrides the entire year and shows the values ​​of the month?

[Andrea_Bertazzo · Accepted solution]

Hi,

I am not sure  that I have understood the question. You want to show the month value if a month is selected or the year if no month selection is made. Is this correct? If so, I would try with an IF,  something like:

=if(GetFieldSelections(Month), Sum( Month), Sum({$<$(GUI_CAL_PA_SET(year,0)), Sales.Open = {'0'}> } Sales))