Waterfall Charts color for case Opening increase decrease Closing
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.