![]() |
Grouping Date Data in a Pivot Table
Hello,
I've created a pivot table that counts daily events and I would like to show that data monthly or weekly by grouping the Date field in my pivot table. Is this possible? Thanks! Raymond |
Grouping Date Data in a Pivot Table
Add the Date field and Right click on it. Select Group and then you can group
by month, quarter, year, ... If you have any trouble then look at this web site... http://www.contextures.com/xlPivot07.html -- HTH... Jim Thomlinson "Raymond" wrote: Hello, I've created a pivot table that counts daily events and I would like to show that data monthly or weekly by grouping the Date field in my pivot table. Is this possible? Thanks! Raymond |
All times are GMT +1. The time now is 12:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com