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

Tagged:

Answers

  • @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.

  • 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

  • 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.