I will have pages of count data as image above:
A – date/time
B- counter 1
C- counter 2
D- counter 3

I want to (I think) use a pivot table to illustrate on another sheet:
Weekly, Monthly and Yearly Totals for each counter which updates itself as I add in more data.

I can get it all into a pivot table and have found how to manually show data ‘between’ two dates but how do I get the monthly etc totals to appear within a table without having to manually select the date range each time… ie. how do I fill the table on the right?

Cheers

If it were me, I think I’d be using a SUMIFS function directly in the data table.

With SUMIFS you can test more than one criteria to be matched, in this case the date and counter 1. You’re going to need the month somewhere though.

Yea your going to need a date some where to get the months, if you want to have filters have a look at using slicers which can be used on multiple pivot tables.

You can right click on the table and group data into months & years

Or have I misunderstood again? ( I can’t see your image)