forecasting revenue

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. 
 

f8ae0525-6e07-4e9c-ac92-d2c2a3bd6e0f.png



 

0 0 96
0 REPLIES 0
Top Labels in this Space
Top Solution Authors