0 Replies Latest reply on Oct 29, 2012 4:29 PM by Lisa Gosling

    How to calculated daily sales from MTD sales

    Lisa Gosling

      I am trying to derive Daily sales from daily MTD sales.  I want  to create a viz that has a running sum of the daily sales.  I have been able to accomplish this by adding a column in my excel worksheet which calculates the daily sales as the difference from the current day MTD Sales and the previous day, but was wondering if this is possible without adding the column in excel.  Notice, there may be days where the MTD Sales is not provided in the excel spreadsheet.

       

      Business UnitDateMTD Sales
      Canada9/1/20120.25
      Canada9/2/20120.53
      Canada9/3/20120.7
      Canada9/4/20120.96
      Canada9/5/20121.17
      Canada9/6/20121.42
      Canada9/7/20121.7
      Canada9/8/2012
      Canada9/9/20122.21
      Canada9/10/20122.44

       

      Here is the viz I am trying to accomplish without adding a daily sales column in excel.sampleviz.jpg