Display sales performance with Pivot Table
Posted on 2006-07-10
I would like to create a Pivot Table with MS Access for tracking the sales of my store.
I have a Table with the following fields:
Date (Date item was sold)
PLU (Item Code - similar to a UPC or SKU)
Quantity (Number sold on this day)
Price (Sell Price of Item)
Cost (Store Cost of Item)
Notes (Text description of Item)
I would like my report to show the sales of items on daily basis in a line graph over a date range I specify (Monthly, then yearly, but the year reports show sums of the monthly sales).
So, PLU 1 will be charted daily across the month, then PLU 2, etc, etc
I have tried playing around with the Pivot Tables, but cannot get the data to to display the way I want. I have also tried exporting the tablet to excel to see if I can get it there, but to no avil there too.
If possible, I would like to have all the PLUs of the month on a single graph, then have each month into it's own report.
If anyone is VB coder friendly, having a form where I can select the criteria, then auto generate a report would be a wonderful feature.