1 Reply Latest reply on Dec 30, 2016 6:19 AM by Norbert Maijoor

    How to break annual forecast down by month?

    Alex Lin



      I have a table with annual forecast value for each product of each customer.


      Below is the example of the data:


      CustomerProductStart DateForecast Value (Annual)
      A12310/1/2016 150,000
      B1235/6/2016 120,000


      The start date is different by customer cause the deals were closed in different dates.


      I would like to break the annual value by month so I can sum up the monthly value. I tried to blend this table with a calendar table, but still can't break the value.


      Can anyone help?