Waterfall chart 1 litem using different versions as starting point and increase/decrease

kinga.markovics

Can anyone advise if the below is possible to do with waterfall?

Taking Forecast total figure & clusters variance to end up to the Total Actuals

So as an example sales:

Total forecast: 100

Europe -10

Asia +40

US -20

Total actual: 110

I have actuals and variance to forecast as versions in Anaplan & sales is a line item. We have a hierarchy 1. total 2. cluster.

See picture how I structed the data source.

I wasn't sure if the total actual is needed or should the start & changes automatically sum up to it.

I'd appreciate any advice. thanks

Kinga

waterfall_84298.png

Accepted answers

kinga.markovics

Hi all

I've solved this myself, and thought to share how.

(1) I created line items for the variances with module applying the entity hierarchy.

(2) After this, I created another module:

(2.1) where I made 1 line item for 1 cluster - for 5 clusters, Net Sales and EBIT variance were a total of 10 line items. In practice my formula looked like this: ACT Net Sales of Cluster 1 - Forecasted Net Sales of Cluster 1

(2.2.) In this module, I also added a Forecasted Net Sales for total segment

(2.3) I created Actual Net Sales for total segment, using a formula to sum up the Forecasted net sales + sum of cluster variances. (so this formula did not refer to any other module, just line items in the same module)..

waterfall_solution_85117.png

All comments

kinga.markovics

Hi all

I've solved this myself, and thought to share how.

(1) I created line items for the variances with module applying the entity hierarchy.

(2) After this, I created another module:

(2.2.) In this module, I also added a Forecasted Net Sales for total segment

waterfall_solution_85117.png

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…