Variance between dimension values in a column chart

[aizhan_k]

Hello,

I need a help.

My setup:

There is a dimension "Production Stage" with three values: "Planning", "Production", "Realise". There is a measure "Cost".

Task is to build a column or waterfall chart that shows costs over production stages and variances between the stages (the screenshot below).

How can I get such setting in SAC?

Any help and tip is welcome.

Thank you and best regards,

Aizhan

[Nverhoeven]

Hi Aizhan,

Understood, I'd first create a simple calculation to compare against "VarianceBase"

IF([d/"planPhase":ProdStage]="Production" ;ResultLookup(["planPhase":Cost] ;[d/"planPhase":ProdStage]="Planning" ) ;IF([d/"planPhase":ProdStage]="Realize" ;ResultLookup(["planPhase":Cost] ; [d/"planPhase":ProdStage]="Production" ) ;null ))

From there I can create the Variance like before: