The goal of this is to dynamically add lump sum of revenue to account for projected/potential revenue) within a pivot a table.
So far I have a table built out with booked revenue monthly to account for revenue I already have, however I am having an issue creating an additional column for future revenue for a distinct month. It’s repeating.
I have an input box dedicated to name so I can see this individually.
Another input box dedicated to adding future revenue.
I'm assuming there is a calculation for this already that I am missing. I have booked spend + future revenue = future opportunities by distinct marketer name.
As seen below I don’t want the $1000 to account for several months and several marketers. I just want it to an addition to the next month of March for marketer inputted.