Immediately below is what has come out despite selecting 'Show intermediate totals'
But below is what I actually want
Solution has now been found. With the help of Level 3 Support (Kyohei)
1. Go into the Module
2. Toggle to Blue Print view3. Scroll to the right and find a Boolean column named "Is Summary"4. Check the "Is Summary" Boolean for line item that needs displaying at intermediate sum
5. The result as below
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?
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.
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.
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
