Excel Pivot table - Data for new year wont update in Pivot Chart?

HI Experts

Hope you can help

I have a basic pivot table / chart containing 2017 data for each month and it has been working fine up until entering this months’ data

There are two tabs – Pivot Table and Pivot Graph containing the raw and visual data, respectively.

When I refresh the data the slicers or graph won’t recognise 2018 data?

I’ve tried re-formatting and re-assigning the data entries but cannot get the 2018 data to appear via the filters.

I’ve attached the file - Would you guys have any suggestions as I’m stumped

Much appreciated as always
Jase AlexanderCompliance ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Lorenda ChristensenAccounting and VBA ConsultantCommented:
My guess would be that your 2018 data IS showing, up, it's just being summed with your 2017 January data. I think the easiest fix is to add a year field to your Pivot. You'll probably want to pretty this up a bit, but I've added "year" to your groupings in the attached.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jase AlexanderCompliance ManagerAuthor Commented:
Hi Lorenda

Wow thank you so much for your help

Its pefect
Lorenda ChristensenAccounting and VBA ConsultantCommented:
No problem. Glad I could help.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.