I have a requirement as follows
I have calendar year, Sale Date and Amount. I need to create a bar chart with 3 bars as follows
Bar1 - Max(calendar Year) showing total amount where Calendar Year =Sales Year and stacked for each Sales Year
Bar2- Max(calendar Year) -1 and Max(Calendar Year)-2 where calendar Year -1 = Sales Year -1 and Calendar Year -2 = Sales Year -2
Stacked by Sales Year
Bar3- Max(calendar Year)-3 showing total amount where Calendar Year-3 =Sales Year -3 and stacked for each Sales Year
How can I do that in Qliksense