Management Report - Waterfall Show intermediate totals not working

Question

Immediately below is what has come out despite selecting 'Show intermediate totals'

But below is what I actually want

LouiseBourgonjon · Answer

Thank you for your suggestion @saglago

The disadvantage is that it gives the impression that we move to (55) which is actually not the case, so it makes the variances look much bigger.

I have decided to leave out the starting base and only focus on the split of the total variances by quarter.

saglago · Answer

Hello @LouiseBourgonjon ,

I couldn't find a straightforward answer but have played with your numbers by rearranging them so that Parent and Is Summary are as below and has worked. I hope is helpful.

IBT_and_Variances_Query_154326.JPG

LouiseBourgonjon · Answer

I tried this but it is still not working for me.

I have a waterfall in which I want to bridge one number to the other by showing the variances per quarter and I also want to show the full year variance as an intermediate total.

Start: NY Plan IBT

Waterfall bars: Q1, Q2, Q3, Q4 variances and Full Year variance as intermediate total

End: NY Plan + Full Year Variance

line items "full year variance" ad "NY Plan IBT" are both marked as "Is summary" in blueprint view.

However, I still don't see the full year variance in the waterfall.

Am I doing something wrong?

IBT_and_variances_154113.JPG