Need to display the year selected

[raghavsurya]

Hi All,

We are currently using a Guage chart to depict the % Sales achieved in current year against previous year. The expression is given as

num(((Sum({<Year={$(=Max(Year))}>} AAmount )))) for the current year. The user wants one box next to the Sales Value to depict the Year to which the amount belongs to. He is not comfortable with the current selected box. Can anyone suggest a work around so that the Year gets displayed against the Sales amount.

Thanks and Regards,

Raghav

[Miguel_Angel_Baeyens]

Hello Raghav,

You may use a text box with

=Max(Year)

or you can add this same text into your gauge chart by changing your expression name to the code above, showing it as title in the chart...

[#3]

As above.

I use the text box option because it allows you to customise the output. Also can serve as a handy data validation tool during development.

[raghavsurya]

Hi Miguel,

Thanks a lot for your suggestion.

Regards,

Raghav