coastie2016
New Member
- Joined
- Jan 26, 2016
- Messages
- 4
Using Excel 2016, I would like to use a pivot table that groups by date into monthly columns (this part is easy), though months from different years should be in different columns (this part I can't figure out).
My current pivot table summarises a few thousand financial transactions and groups summarised data into monthly columns. The dates in the records span multiple years and the grouping in the pivot table combines the data from separate years into the same monthly column. For example, records from Jan 2016 are grouped with records from Jan 2017.
I would like to be able to separate the summarised data for these records into separate columns (months) in the pivot table.
I would then end up with columns for Jan 2016 to Dec 2016, followed by columns for Jan 2017 to Dec 2017.
Is this possible to achieve?
My current pivot table summarises a few thousand financial transactions and groups summarised data into monthly columns. The dates in the records span multiple years and the grouping in the pivot table combines the data from separate years into the same monthly column. For example, records from Jan 2016 are grouped with records from Jan 2017.
I would like to be able to separate the summarised data for these records into separate columns (months) in the pivot table.
I would then end up with columns for Jan 2016 to Dec 2016, followed by columns for Jan 2017 to Dec 2017.
Is this possible to achieve?