How to create accumulated bar chart

[#1]

Hello,

I need to create bar chart for 2014, 2015 and 2016 revenue. I only need to accumulate revenue for each year.

I don't want to create three chart. I want to put them in one chart.

Can you help?

I attached my excel file of this requirement.

Thanks,

Dust

[Gysbert_Wassenaar · Accepted solution]

Create a year field. Use the year field and the month field as dimensions and enable full accumulation for the expression.

See attached example.

[#3]

Hi Gysbert Wassenaar,

Appreciate your solution.

Looks like we are very close. Do you have a way to show this chart year by year and side by side? Just like I showed on my excel file.

Thanks,

Dust

[Gysbert_Wassenaar]

That requires a different approach. See attached qvw.

[#5]

Thank you very much - Wassenaar.

The first solution works. This one is another solution on my question. Very creative.

Your help is greatly appreciated!