0 Replies Latest reply on Jul 19, 2013 10:20 AM by Neal Smoller

    Monthly Projection

    Neal Smoller

      Our data is a traditional retail store.  Our line items look like this:

       

      invoice id, item, quantity, extended price, date

       

      The SUM(extended price) gets us total sales, separated by month gets us monthly sales.

       

      Currently, in excel, we've setup the following

       

      (Sales To Date/Days to Date)*(days in this month) to generate a projection for the month.

       

      how can i replicate this in tableau?