Combined Stacked and Grouped Bar Chart

[timbatman]

I have four variables of interest:

Q1CompCost, Q1WaterCost, Q2CompCost, Q2WaterCost

I wanted a stacked bar chart by quarter, but I can seem to only get all 4 variables to stack or all 4 to be side by side.  Any ideas?

[Claudiu_Anghelescu]

Dimension1:

=valuelist('Q1CompCost', 'Q1WaterCost') 

Dimension2:

=valuelist('Q2CompCost', 'Q2WaterCost')

Expression Q1:

=if(valuelist('Q1CompCost', 'Q1WaterCost') ='Q1CompCost',
sum(expr))

Expression Q1:

=if(valuelist('Q1CompCost', 'Q1WaterCost') ='Q1WaterCost',
sum(expr))

Expression Q2:

=if(valuelist('Q2CompCost', 'Q2WaterCost') ='Q2CompCost',
sum(expr))

Expression Q2:

=if(valuelist('Q2CompCost', 'Q2WaterCost') ='Q2WaterCost',
sum(expr))

Put the same name for both expressions in each Quarter: Q1 and Q2 for example

[Claudiu_Anghelescu · Accepted solution]

if not works you can try also this:

Dimension:

=valuelist('Q1', 'Q2') 

Expression Q1:

=if(valuelist('Q1', 'Q2') ='Q1',
sum(Q1CompCost))

Expression Q1:

=if(valuelist('Q1', 'Q2') ='Q1',
sum(Q1WaterCost))

Expression Q2:

=if(valuelist('Q1', 'Q2') ='Q2',
sum(Q2CompCost))

Expression Q2:

=if(valuelist('Q1', 'Q2') ='Q12,
sum(Q2WaterCost))

...and use the same color for each measure.

[timbatman]

Thank you, worked perfectly.