How to include selected year and previous year in bar chart

[balajisj30]

Hi people

How to include sales values of the selected year and previous year in the same bar chart.

Thanks

Balaji

[OmarBenSalem]

let's suppose that ur measure is :

sum(Measure)

and that u have a field called YearField in ur data

in ur bar chart:

as dimension : YearField

as measures:

1) sum({<YearField={"$(=max(YearField))"}>}Measure)  //this is the selected year

2) sum({<YearField={"$(=max(YearField)-1)"}>}Measure)  //this is the selected year-1