7 Replies Latest reply on Jun 5, 2015 3:10 AM by kettan

    Create Date to divide data across

    Kevin Capizzi

      i currently have a data set that is a total number by customer. i would like to be able to spread the total sales number across 12 equal months. I have created a few calcluated fields:


      Start Date



      End Date



      Month Period

      DATEDIFF('month',[Start Date],[End Date])+1


      Monthly Sales

      [Est Revenue] / [Month Period]


      My goal is to create a viz that shows each of the monthly sales applied to the months.

      Any ideas?