Share via

Adding YTD data to a pivot table

Anonymous
2016-11-11T16:32:43+00:00

Hello,

I have a spreadsheet that has data from 10/1/2015-9/30/2016, which has the months listed as labels as 10, 11, 12, 1, 2,3, 4, 5, 6, 7, 8, 9. I updated the report the pivot pulls the data from to include 10/2016. However, when I refresh the pivot, instead of added a column labeled 10 after 9, it is including the data in the first column labeled 10, which is actually from 2015.

Any assistance is always appreciated!

Thank you!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2016-11-12T20:41:13+00:00

    Hi Timothy,

    When you labeled the names of for the months? have you included the Year as well or is just the number that correspond to the month.

    We look forward to your reply.

    Was this answer helpful?

    0 comments No comments