I'm looking for advice on how to create a certain type of
My data looks like this:
Select Date, Product, NumberSales, Price, TotalSales
I want to create a report that compares sales over several
days like this:
Product Sales | Number of Sales | Price | Total Sales |
Product Name | Today | -1 day change | -2 day change | Today | -1 day change | -2 day change | Today | -1 day | -2 days |
Product 1 | 5 | +1 | -3 | $30 | - $32 | +$23 | $150 | -$100 | + $40 |
In the "Today" column I'm using actual value from my query,
but in the -1 and -2 day change columns I'm using a value
of the difference between Today and previous days data.
Is there a name for this type of report that I can use to
research ways to do it?
Or even better, are there any examples on how to do this type of report?
Right now I am thinking I'll create 1 or more queries for my main data.
Then somehow query that query data to create the calculated columns.
The calculated columns would be specified in the report and the rows would
repeat for each product. I'm not sure if this is the best way to go about
doing this type of report?