1 Reply Latest reply on Mar 24, 2015 1:45 PM by John McIntyre

    Monthly movement calculation help

    angela.crewther

      hi - I need to calculate a monthly movement on reports I receive that come in as a YTD value. If I have manually put all the reports into one sheet with a date field what is the best/easiest way for me to calculate this movement in tableau now?

      eg below - i want to create the last column in this example without doing this manually as there are over 3000 companies to match off each month.

      Date          Company          YTD $          Monthly $

      7/1/2014      Company1     $100000          $100000    

      8/1/2014     Company1     $250000          $150000

       

       

      thanks