Is This Even Possible?

[dustonmoore]

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.

[Anil_Babu_Samineni]

You have to calculate like below

Sum({<QuanrterName=>} Sales) + 0.01

Or

=SUM({$<QuarterName={"=$(=fractile($(=Min(QuarterName)),0.1))"}>} Sales)

[dustonmoore]

But how do you get Q1 2016 + 0.01 to show on top of Q1 2017??

[Anil_Babu_Samineni]

Will you able to share sample application

[dustonmoore · Accepted solution]

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