Waterfall Chart - Positive values start from previous line item

Hi, Anaplan Community,

I have a question about the Waterfall Chart in the UX.

I'd like to have the positive values start from 0 instead of the previous line item. I would appreciate your input/assistance.

Backend:

Accepted answers

All comments

Vinay VaradarajM

Hi @sosunkwo ,

It looks like the setup does not have formulas for sub-totals and totals. In this case, I believe Gross Margin should be derived from previous line items which will assign relationships to display the waterfall.

Please check if the below helps you:

Screenshot 2022-12-02 at 1.15.51 PM.png

Regards,

vinayvm

sosunkwo

@Vinay VaradarajMplease can you elaborate.

Vinay VaradarajM

Hi @sosunkwo ,

Waterfall charts need summaries defined by way of formulas. Below is the same example with blueprint view:

Sub-total = sum of the first 4 line items

Total = Sub-total + copay + Other costs

Screenshot 2022-12-02 at 2.29.55 PM.png

By doing this, the system assigns parents and summaries to line items which help in displaying waterfall charts:

So effectively, you need to have sub-totals/totals line items which aggregate the underlying information to display waterfall chart. These columns for sub-totals/totals start from zero unlike the rest.

Hope this helps!

vinayvm

sosunkwo

@Vinay VaradarajMWhere are your Net Demand & Gross Margin Line items?

Vinay VaradarajM

Hi @sosunkwo ,

Basically, the line items which you would want to start from zero should be your sub-totals/totals, which in this case are Net Demand and Gross Margin.

regards,

vinayvm

Quick Links

Can you help?

Unanswered questions

Looking for Anaplan End-Users to take a short survey!
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
PlanIQ Error Messages and Warnings
Users may encounter error and warning messages in PlanIQ. The table below includes descriptions of the messages and details what should be done in order to address them, where applicable. Message types: * Errors will fail the relevant PlanIQ step. Users will have to follow the instructions in order to avoid the errors. *…