max year

[vignesh_s]

i have cleard the dash board ,now i wanna dispaly max year details even after i clear ,but without triger

[Anil_Babu_Samineni]

No way, I feel it as always maintain Variables for future maintenance. So, that is very easy to change for all sheets at a time effect for single change. This time, you cannot do that maintain.

[devarasu07]

Hi,

without trigger you can go with Avinash suggestion. try to do below steps,

1) create variable

vMaxYear

=max( {1}Year)

2) create any chart object then try to use that variable in your chart expression,

for example,

sum( {$<Year={$(vMaxYear)}>}Sales)

[vignesh_s]

oh ok thanks

[its_anandrjs]

I believe if you use =Max(Year)  and even if you clear the selections you get max value of the year.