How can i compare average sales of current year and last year in a gauge chart?

[Anonymous]

Hi,

I want to calculate average sales of current year and last year. And want to compare these values and present in a gauge chart.

Need help.

Thanks

[kaushiknsolanki]

Hi,

Try below expression.

Avg({<Year = {"$(=Max(Year))"}>}Sales)/Avg({<Year = {"$(=Max(Year)-1)"}>}Sales)

Regards,

Kaushik Solanki

[sudhirpkuwar]

Its difficult to represent the CY and LY comparison in a gauge chart.

You can use some other chart like Bar chart