Stacked and Clustered Column

[anthony-gb]

So I am having trouble with visualizing data in a certain way. I'd like to produce something similar to this, except just the actual is stacked.

I have the following tables

1. The Sales Table- https://prnt.sc/10fqy10

2. The Budget Table which stores the year and the target date, and the connection to the store hierarchy https://prnt.sc/10fr03l 

3/4.  the store and department tables which link the budget to the store/department 

What I am hoping to achieve is the following.

on the X axis, i'd like the Budget Year (eg. 2017/2018)
I would like two columns per year
1. The sum of the Budget Amount for the Year

2. A stacked column of the contract_amount, broken down into stage.

My problem is that when I try to make a stacked chart, it also adds the budgeted amount sum, when I want that in a separate column and just stack the contract_amount. I have made this data up to illustrate the problem in the attached excel file.

Is there some way to achieve this? I would be happy to solve with a paid extension if it makes it easier to produce these, I can do it in Excel.

[tm_burgers]

Unfortunately a stacked and grouped bar chart is not an available visualization. 

[KL1]

please watch the below video: 

https://www.youtube.com/watch?v=KwyqkOt6RJQ