Hello everyone - I have a requirement to build a waterfall chart on a cumulative field . (Ideally we build waterfall chart for actual numbers. )

The issue I am facing now is when I add a field called Age group to the color legend the waterfall is off , can anyone suggest what should be the table calculation in this scenario ? I have attached the screenshot of the split waterfall for your reference.