Originally Posted by
Richard Buttrey
Hi,
I've added a data filter as well so that when you change the date on the Daily Purchases sheet the data changes.
The Pivot table is essentially the same but I've just tidied it up a bit.
One new bit of functionality you may or may not want. Go to the pivot table and double click any of the numbers in the total column. See immediately how a new sheet is added and populated with the records from the database that supports the total.
You may never use it but I mention it as just another bit of PT functionality. Right click on any sheet tab name that's added and delete it whenever you want - or of course choose Delete Sheet from the menu.
Bookmarks