How to Get the Year Wise Comparisons In Charts

[#1]

Hi Community Members,

I want to compare the sum (sales) with previous Year  in chart, i.e when I select a 2006,it should be display chart with 2007  and 2006 years data in a chart.Thanks in advance.

Regards

Rams

[christophebrault]

Hi,

set month as a dimension and then 2 expressions :

sum({$<Year={$(=Max(Year))}>}Sales) // the year selected

sum({$<Year={$(=Max(Year)-1)}>}Sales)// Past Year

[#3]

Thanks christopher ,I got in bar charts ,but I am unable to get it in Guage charts.Can you help me please

Regard

rams