Hi All,
I've got a line chart that shows drama school sales for the current fiscal and is getting to be quite long and not very useful for seeing sales trends. I would like to change it so that it just shows the last 30 days of sales trends. However, if I filter on orders in the last 30 days it doesn't show the proper total.
This is the full chartThis is the chart with a last 30 days of orders filterOther ideas for how I can make this more visually useful? We will continue to add more seasons as time goes on for Winter and Spring classes, so it's only going to get harder to read.
Is there any way to get around days within the 30 day period with no sales? Those cases, I'm seeing just the last 360 days total, no RSUM added.
Editing to add: I'm doing this in a pivot table and adding RSUMs of two different price types together in a column. On days where there are no sales in price type 1, the cell only shows the RSUM for price type 2.