Waterfall chart

Hi,

Waterfall chart is showing for all values as "Upwards direction" as shown below:

I WAS EXPECTING to be like this below.

Does we need to write any expressions/formula to set Net1, Net2, Net3 and NetRevenue to start from 0 instead of prev line item ?

Thanks,

Satish.

Accepted answers

All comments

?.Szyma_ski

Hi Satish

What I've noticed you're using components (Gross Revenue, GPO, etc.) as list members with Rebate $ as line item. You should consider creating module with those components as line items (see screen below). This module doesn't have any other dimmensions. In your case you should replicate all additional dimmensions (Time, Versions, Lists) from original module. Waterfall chart.PNG

All items displayed in black are simple sums of proper items.
Net1 = Gross Revenue + GPO + Fed

Net2 = Net1 + Medicaid

Etc...

Now marking single column from Gross to Net Revenue and selecting waterfall chart should create below chart. waterfall chart actual.PNG Hope that will provide help you needed.

Kind regards,

Lukasz

Quick Links

Can you help?

Unanswered questions

AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…