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

    How to break annual forecast down by month?

    Alex Lin

      Hi,

       

      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?

       

      Thanks,

      Alex