Dynamic Expression Labels

[Anonymous]

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

[Anonymous]

Can Anyone Help please..........

[#3]

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

[Anonymous · Accepted solution]

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

[#5]

sorry let ma correct my answer you need to write:

=if(Month <= Month(Today()),'Sales Previouse','Forecast')

regards,

MT

[tresesco]

Nitin Gupta

Your understanding is correct. Label doesn't recognize dimension values. Therefore you won't get different labels for any dimension.

[Anonymous]

Whats the difference in both of above...

They are same ...

[Anonymous]

Hi Tresesco,

I there any other way around to fullfill the requirement.

[#9]

no one has an equal-sigh (=)

[jagan]

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.