dynamic title

[master_student]

Hello Guys,

I would like to have a dynamic chart title that change with the year selected for example Recharge 2016 vs 2017

any idea please?

Thanks

[sunny_talwar]

May be this:

='Recharge ' & (Max(Year) - 1) &  ' vs ' & Max(Year)

[sdmech81]

HI you can write expression in chart title aswell..Try that

Else give me exactly what you want

[sdmech81]

Try this:

='Recharge ' & (Max(Year(Today())) - 1) & ' vs ' & Max(Year(Today()))

[gowtham_patnaik]

Try this:

try to store year in a variable.

='Recharge' & sum($(vYear)-1) &  ' vs ' & sum($(vYear))