ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Grouping Date Data in a Pivot Table (https://www.excelbanter.com/excel-programming/392116-grouping-date-data-pivot-table.html)

Raymond[_2_]

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



Jim Thomlinson

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