Solved

[microwin88x]

Solved

[Gysbert_Wassenaar]

Not really. With two dimensions you can only use one expression. See attached qvw for the closest I can come to your requirements.

[agilos_mla]

Hi,

You might find how to build the viz you want at : http://qvdesign.wordpress.com/2012/08/24/the-breakdown-bar-chart-a-little-bit-more-in-certain-circum...

hope it helps,

Michael

[sebastiandperei]

You should put the expressions in a Dimmention.

1- First Dimmention, a calculated one like: Valuelist('phase 1','phase 2','phase 3')

2- Second Dimmention, the field that are in the different colours in Waterfall2.png

3- One expression:

= Pick ( Match (Valuelist('phase 1','phase 2','phase 3'),'phase 1','phase 2','phase 3'),

               sum(ph1),          // your phase 1 expression

               sum(ph2),          // your phase 1 expression

               sum(ph3)          // your phase 1 expression

              )

Try and tell me!

[#5]

Hi Gysbert:

Will your method works when the elements in the second dimension for each group of the first dimension are not the same.

Something like:

Make (Dimension 1)	Model (Dimension 2)
Toyota	Corolla
Toyota	Camery
BMW	1 Series
BMW	4 Series
BMW	5 Series
VW	Golf GTI

If that is the case, how would you do the bar off set?

Thank you very much.

PC

[sebastiandperei]

??? please, close this post!!!

[#7]

Hi,

Is there any option to get Total on Left side instead of right side in the water fall chart that is shown in the above example?(with out Hard coding in the Dimension)

Thankyou

Ramgopal

[erikzions]

Sebastians method worked for me.