Register

Waterfall

tderuyver
New Contributor

Waterfall

Hi,

 

I would like to create a Waterfall chart.

I have 3 FY, and a list of locations, and the final result should be as this picture :

tderuyver_0-1605022251987.png

 

However, this waterfall chart has been done only via line items :

 

tderuyver_1-1605022354639.png

 

Is there any different ways to do that, in order to have "Fr", "UK", etc... between FY19 and FY20, and between FY20 and FY21, without the obligation of changing names.

 

Many thanks in advance for your help.
Kind regards,

Thibaut

3 REPLIES 3
ChrisHeathcote
Community Boss

Re: Waterfall

@tderuyver 

Is there a specific reason why you are not using a list for the countries and Anaplan time?

Build a module using lists and time and nest countries and time to create the required format.

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
tderuyver
New Contributor

Re: Waterfall

Hi,


The reason I don't use countries as a list and Anaplan time is  that I can't make a chart with 2 dimensions :

 

tderuyver_0-1605185997569.png

 

How could I proceed ?

 

Thanks for your help,

Thibaut

ChrisHeathcote
Community Boss

Re: Waterfall

Unfortunately, waterfall charts are created using line items.
I would question what you are trying to achieve using this type of chart and explore other options where you can use lists to format the grid that contains the data.
Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA