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?
Retrieving data ...