Waterfall Charts color for case Opening increase decrease Closing

Highlighted
Frequent Contributor

Waterfall Charts color for case Opening increase decrease Closing

Hi all,

I am creating a waterfall chart for a movement use case. The movement use case starts with Line Items Opening, Increase, Decrease and the Closing (being the Parent). The Increase and Decrease should red/green depending the contribution to the Closing. The Opening and Closing should be blue. 

The challenge is to get the Opening blue, Closing is no problem. I am able using a workaround to get Opening blue by adding a Line Item which sum into the Opening but then I also need to take this additional Line Item to the waterfall chart.

 

Anyone with another solution? Looking forward to your reply.

 

Kind regards,

Johan