Hi
I have created a gauge that shows a defined target value based on the sub-region using the formula below, and it is working well.
IF ($subregion="Oceania",186,IF($subregion="PR China",84,IF($subregion="Japan",133,IF($subregion="South Asia",100,IF($subregion="East Asia",143,646)))))
However, the target value actually gets less each month. What I have put above is actually the target value for the end of the year (Dec) rather than the current month. Is there a way to add this into the above filter?
Thanks
DD