I have this waterfall chart as below where various metrics are shown starting from Visibility. RFF is a target value here and should be shown separately and not add up to rest of metrics. How can we achieve that in the same chart? I am using below custom expression in the Value axis.
Expression
Sum([Visibility W1 USD]) as [Visibility USD], Sum([CP Risk W1]) as [CP Risk USD], Sum([Conf Level>80% W1]) as [Conf Level>80%], Sum([Conf Level60%-80% W1]) as [Conf Level60%-80%], Sum([Conf Level40%-50% W1]) as [Conf Level40%-50%], Sum([Conf Level<40% W1]) as [Conf Level<40%], Sum([RFF]) as [RFF]