Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need a bar chart that displays last year's quarterly sales dollars and I need this year's quarterly sales dollars next to last years. Then I need a line graph on top of this that takes the previous years (quarterly) sales dollars, add 10% to that amount, and display it 1 year in advanced (so Q1 2016 + 10% displayed over Q1 2017) . I would also like for the line graph to "push" 3 months in advanced.
Is this possible?
I have included an image of what I want. This is fake but should help in understanding.
Here it is....
Selected year -1 (or max-1)
Sum({<year= {$(= max(year-1))}>} sale_amount)
Selected Year (or max)
Sum({<year= {$(= max(year))}>} sale_amount)
Previous year + 10%
Sum({<year= {$(= max(year-1))}>} sale_amount)+ Sum({<year= {$(= max(year-1))}>} sale_amount)*.1
You have to calculate like below
Sum({<QuanrterName=>} Sales) + 0.01
Or
=SUM({$<QuarterName={"=$(=fractile($(=Min(QuarterName)),0.1))"}>} Sales)
But how do you get Q1 2016 + 0.01 to show on top of Q1 2017??
Will you able to share sample application
Here it is....
Selected year -1 (or max-1)
Sum({<year= {$(= max(year-1))}>} sale_amount)
Selected Year (or max)
Sum({<year= {$(= max(year))}>} sale_amount)
Previous year + 10%
Sum({<year= {$(= max(year-1))}>} sale_amount)+ Sum({<year= {$(= max(year-1))}>} sale_amount)*.1