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

vinayvm

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.

vinayvm

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?

vinayvm

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

REST API V2 after 16-Feb-2026 for CA Certificate authentication
Hi Does anyone successfully find the correct way to adapt the REST API scripts according to the new API v2 CA Certificate standards: adding the new parameter "encodedDataFormat": "v2", I tried to prefix the encodedData using the timestamp (also UTC), using 8+92 or 8+100 bytes but I did not find the right combination…
RTO and RPO details required
For auditing purpose I need RTO and RPO details. Could you please share the details and also along with the source URL.
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
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…