Hello,
I have 5 tables and created 4 pivot tables, labeled 1-4 on the 'Charts' worksheet. Connections have been reported and the timeline slicer works great for pivots 1-2. Pivot 3 won't update with the slicer and pivot 4 is updating with data from wrong period.
I believe the connections work and are correct, they linked columns don't have duplicate data and have the same data type. I suspect there is an issue with the differences in the number of 'dates' in each table, but am not sure.
I am not sure what to look for next, and any help would be appreciated. The file is attached, feel free to make any adjustments necessary.
Thanks,
Sean
Bookmarks