8 Replies Latest reply on Sep 4, 2018 8:45 AM by Imran Azam

    Calculate monthly sales from given start and end date

    Imran Azam

      I'm trying to calculate monthly sale from a single record Monthly recognisable sales.  Monthly sale would be  (Total / length of contact). I want this spread  monthly over the length contract. For example: below is  the table

       

      Name
      start date
      end date
      total
      length of contact
      subscription 101/04/201831/08/20187005

       

      How can I get tableau to show the 'monthly sales  in months between the start and end date?

       

      i want to show its something like below

       

      Name
      start date
      end date
      total
      length of contact30 April 2018
      31 May2018

      30 June 2018

      31 july 2018

      31 august 2018

      subscription 101/04/201831/08/20187005140140140140140

       

      can this be done?

       

      please note this is one subscription i have loads in my data, 

       

      I have attached the tableau workbook on to this ( this  example has 3 subscriptions)