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

      DATE("1/1/2015")

       

      End Date

      DATE("12/31/2015")

       

      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?