Stacked Bar chart with 2 expressions and 2 dimensions

[#1]

Hi, i want to create a stacked bar chart with 2 expressions (ACT vs BDG) and two dimensions, first one in x axes (BU) and the second one stacked (AREA ICT). I would these two charts in a single one with ACT and BDG side by side:

See qvw attached

[sunny_talwar]

Like this?

Added a new table in the script:

Dim:

LOAD * Inline [

Dim

1

2

];

and used it as a dimension

=Pick(Dim, 'ACT', 'BDG')

Expression

Pick(Dim, Sum([BUDGET SENZA MANODOPERA]), sum([BUDGET 2017 (Approvato)]))

[#3]

Yess, you are a genius! Can you please reattach me the qvw with solution?

[kaushiknsolanki]

Hi,

Check this.

Regards,

Kaushik Solanki

[sunny_talwar · Accepted solution]

Sure

[#6]

Super Kaushik! Thank you very much!

[hector_munoz]

Hi Stefano,

That is not possible with a bar chart; you can show 2 dimensions and 1 expression or 1 dimension and 2 expressions. I think here you have 2 simple possibilities:

• Concatenate 2 dimensions in 1 (=$(=Only(Dimensione)) & '-' & $(=Only(Dettaglio))) and show 2 expressions.
• Use a grid chart

I attach a sample of second option.

Regards,
H

[hector_munoz]

Very well solved Sunny!

[sunny_talwar]

Thank you

[#10]

Hi, it's possible introduce total? I would 2 bar (one total for Budget and one for Actual)... like this:

thx