Modify Running SUM Calc - Add Label to Bottom of Waterfall

Hi everyone,

I need to add a label to the bottom of each bar within a Waterfall. I found a way to do this, but I can't figure out how to modify the running sum calc so this solution will work for the entire viz.

Here's where I'm at:

1. I created a dual axis chart. Both axis will be the same - I'm doing this so I can put a specific value at the bottom of each bar.
2. The brown bars (subtotals) don't need a value in the bottom chart

Left Side - Works great

• 2281 - 663 = 1618 (shows up exactly where it should)
• 1618 - 761 = 857 (shows up exactly where it should)
• 857 - 150 = 707 (shows up exactly where it should)
• 707 - 5 = 702 (shows up exactly where it should)

Right Side - Needs fixin'

• The calc is working as it should, however, I need to go a level deeper and subtract the individual value from the running sum to achieve my objective
  • 702 + 8 = 710 (running total, where it's at currently)
    • 710 - 8 = 702 (running total minus bar's value; it'll be at the bottom of bar)
  • 710 + 27 = 737 (running total, where it's at currently)
    • 737 - 27 = 710 (running total minus bar's value; it'll be at the bottom of bar)
  • 737 + 349 = 1086 (running total, where it's at currently)
    • 1068 - 349 = 719 (running total minus bar's value; it'll be at the bottom of bar)
  • 1068 + 303 = 1389 (running total, where it's at currently)
    • 1389 - 303 = 1086 (running total minus bar's value; it'll be at the bottom of bar)

I'm sure there's a way to do this by modifying the running sum calc and using conditionals to specify how a value for a certain Movement Type should be handled, I just can't figure it out. Any help would be much appreciated!