Months / Dates in Pivot Tables

D

Dave Eade

Hi,
I have a PT with about 300 records, each record has a date in the format
dd/mm/yyyy - how do I get my PT to group dates into months so that I can
either count or sum the records created within a month - I think I need to
group them somehow but can't see how I do this.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
How to add day to PWA 2016 date format? 0
Pivot table 0
counting records by month and year / date format issues 2
Dealing with a Pivot Table (when I don't want to) 0
Date Formats 4
How do I create unique pivot tables from the same data 1
converting dates from file 3

Top