Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi people
How to include sales values of the selected year and previous year in the same bar chart.
Thanks
Balaji
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