Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
As shown in image, I have a requirement that I want label of expression change on basis of dimension(Year Month).
If Year month is greater than that of today the value should be different.
Kindly help....
Regards
Nitin
I have used the same expression, but its not working.
I think labels works as text boxes so according to dimensions they do not vary
Can Anyone Help please..........
what kind of chart are you using?? in a pivot table you could wite:
if(Month <= Month(Today()),'Sales Previouse','Forecast')
hope this helps!
regards,
MT
I have used the same expression, but its not working.
I think labels works as text boxes so according to dimensions they do not vary
sorry let ma correct my answer you need to write:
=if(Month <= Month(Today()),'Sales Previouse','Forecast')
regards,
MT
Your understanding is correct. Label doesn't recognize dimension values. Therefore you won't get different labels for any dimension.
Whats the difference in both of above...
They are same ...
Hi Tresesco,
I there any other way around to fullfill the requirement.
no one has an equal-sigh (=)
Hi Nitin,
Please find attached file. Label doesn't recognize dimension values, so it is not possible, create a calculated dimension like in attached file.
Regards,
Jagan.