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