Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)]))
Yess, you are a genius! Can you please reattach me the qvw with solution?
Hi,
Check this.
Regards,
Kaushik Solanki
Sure
Super Kaushik! Thank you very much!
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:
I attach a sample of second option.
Regards,
H
Very well solved Sunny!
Thank you
Hi, it's possible introduce total? I would 2 bar (one total for Budget and one for Actual)... like this:
thx