Guidance on writing query for chart or pivot chart
I want to build a query using data from sheet 1 of the attachment for the purpose of building either a chart like in chart 4 of the attachment, or a pivot chart. This chart shows a running sum of items per employee for the most recent 30 days. Ideally I could make a pivot chart to filter data by supervisor and employee.
The approach I have in mind is to build a query similar to what is in sheet 2 of the attachment, possibly using a crosstab. Also, getting the 30 most recent dates is a bit of a challenge as access doesn't support a BOTTOM syntax similar to the TOP syntax.
Before I get too far on this, anyone have guidance on the best way to approach this (or if you already have a query or set of queries that does this, all the better!)