Forum Discussion
Pivot table displays month and year; but not month in both columns for 2017 and 2018
I have a pivot table in Excel 2016 summarizing expenses by activity period by month and year. I would like to sort the pivot table in calendar order, but I can't separate Jul 2017 and Jul 2018. The...
Can you upload a file with anonymised data so we can have a look?
Thanks, Jan. I believe I answered my question by doing the report with anonymised data.
When I added the activity period field to the field list, it automatically checks quarters and years. I unchecked quarters and then had 2 columns on the pivot table for 2017 and 2018.
Then I clicked the + sign by both 2017 and 2018 and presto! My months are sorted in calendar order!
Thanks for your assistance!
- Always great if you can answer your own question :-)
