Hi,

I have a list of dates and data that go back a year. In Excel I made a pivot table that shows all these dates. In the columns label under data filters I see a lot of weekly, monthly, yearly information that is available but the one Im looking for is the one that will separate my dates by each month similar to the quarterly function.

Is this something I can do with in the pivot table function or would I need to do something else, and if I do can you give me some advice as to how I can do this,

Thanks for your time and help

Hi,

I have a list of dates and data that go back a year. In Excel I made a pivot table that shows all these dates. In the columns label under data filters I see a lot of weekly, monthly, yearly information that is available but the one Im looking for is the one that will separate my dates by each month similar to the quarterly function.

Is this something I can do with in the pivot table function or would I need to do something else, and if I do can you give me some advice as to how I can do this,

Thanks for your time and help

1. In the Pivot Table click somewhere in the column that contains the dates then:-

PivotTable Tools

Options contextual tab

Group group

Click on:-

Group Selection

 - so that the window called:-

Grouping

 - opens.

2. In the window called:-

Grouping

 - click:-

Months

 - then click:-

OK

All your data for all the years is now sorted into months.

Does that give you what you want?

• Edited by trip_to_tokyo 17 hours 34 minutes ago

Hi,

I have a list of dates and data that go back a year. In Excel I made a pivot table that shows all these dates. In the columns label under data filters I see a lot of weekly, monthly, yearly information that is available but the one Im looking for is the one that will separate my dates by each month similar to the quarterly function.

Is this something I can do with in the pivot table function or would I need to do something else, and if I do can you give me some advice as to how I can do this,

Thanks for your time and help

1. In the Pivot Table click somewhere in the column that contains the dates then:-

PivotTable Tools

Options contextual tab

Group group

Click on:-

Group Selection

 - so that the window called:-

Grouping

 - opens.

2. In the window called:-

Grouping

 - click:-

Months

 - then click:-

OK

All your data for all the years is now sorted into months.

Does that give you what you want?

• Edited by trip_to_tokyo Thursday, April 30, 2015 1:53 PM