Forum Discussion

GadgetGill's avatar
GadgetGill
Copper Contributor
Jan 20, 2025

Pivot Table "Change Source" messes with dates

I am using a Pivot Table (created by someone else), which provides a batch of information by Month / Year.   It's working fine, but we realised that the Pivot Table wasn't including the information for November / December 2024.   When we use "Change Source" for the data, and include the additional rows from the same data table,  the Filter starts including multiple entries for each month (it wasn't doing that before): 

 

 

How can I fix this? 

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor

    Have a close look at your data. Are those Jan-19 and Feb-19 dates true dates? Perhaps they are all in Jan/Feb, but on different days?

Resources