Combo chart with both Bars and Stacked bars?

[orangebloss]

I have the following chart that has five measures:

I want to be able to stack the Original estimate and the Additional estimate to show the overall estimate against the remaining 3 measures - is there a way to do this? 

[sbaro_bd]

Hi @orangebloss ,

You can create this chart but you have to calculate your measures in your script and store them in a table. Take a look on the attached application.

Regards.

[orangebloss]

Hi Thanks for this - I'm not sure how I would implement this without loading the inline table?

Each row of data will have a value but I don't know how I would then duplicate that to create a second set of 0 values?

[sbaro_bd]

Hi @orangebloss ,

If you can, attach your app with a sample of your data. It will be more easy to help you with your script.

Regards.

[orangebloss]

Script attached below - it's in four parts and hopefully make sense!