Forum Discussion

Pfoerster's avatar
Pfoerster
Helper III
5 years ago

Waterfall with Subtotal

Hello,

again, I am struggeling at a very specific problem, and perhaps, you have a solution: 

I would like to create a Waterfall Visual, where I explain the current evolution of turnover, started with budget to last updated forecast and ending at current value:

When I am doing so, I can not get the Last Updated Forecast as a subtotal but also as value, which is added to the waterfall:

 

This is the way, how I am getting to that picture:

Waterfall Value = SWITCH(SELECTEDVALUE(Waterfall[Index]),1,+[NTBudGraph],2,+[EffectVolumeLUFvsBUD],3,+[EffectPriceLUFvsBUD],4,+[EffectMixLUFvsBUD],5,[NTPlanGraph],6,+[EffectVolumeACTvsLUF],7,+[EffectPriceACTvsLUF],8,+[EffectMixACTvsLUF],Blank())
 
My Category in the Waterfall is the "Name" (to get the "Budget Turnover", "Volume Effect"...) and as Value, I used the formular.
 
Do you have any suggestion, how to get the LUF Turnover as subtotal in between?  
Need Help

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    Hi Pfoerster ,

     

    To do this secondary baseline value you need to have a breakdown category to have that additional level.

     

    You can also search on the Custom visuals, or if this does not work you can also try and make your own  chart with a stacked column chart.

     

    I had some success in doing this using a category table and some measure for the positives, negatives, total values.

     

    Just trowing options not really abble to replicate your needs without a sample data.