Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i am implementing a dynamic chart in dimensions.
Based on your choice of current month or year to day (YTD), I dynamically change the size of the chart.
when i choose the YTD i would like the size to be the last 3 years.
otherwise I use the months of the last year
to do this I use the following code.
= if
(ThFilters.CMYTD = 'CM',
led2_month
,
ValueList (led2_anno-2, led2_anno-1, led2_anno)
)
The editor doesn't give me any problems. gives me the OK.
The problem though is that the graph gives me the wrong size.
The problem is that the chart does not recognize the use of the ValueList when inside IF.
If I use only ValueList instead I have no problem.
Where am I wrong?
May be try PICK MATCH function
?