Pivot chart-data from more than one year, expand collapse months in diff yrs independently

[bradwp]

I've searched and searched the interwebs to no avail (part may be the non-simple way to explain my issue), but I can't find any similar situations.

My issue is this:
I use a workbook that takes order data from a server export and tracks my Shipping Dept's daily order fulfillment performance. Occasionally I will archive old data, pulling it out of my "working" copy, but I want to keep more than one year of data. For my Pivot chart I like to keep the most recent few months expanded to show daily data, but anything older collapsed to show the average for the whole month. My issue is that whenever I get more than a year of data on a Pivot Chart I can't expand or collapse the months independently across years, e.g. I can't display July 2019 daily data without also having July 2018 expanded to daily data.

My google-fu is usually pretty strong in that I can find the answer to any of my excel questions without posting, but I can't seem to find a similar issued posted anywhere. Is it related to my date formatting, a know limitation in Pivot, or something else?

I've attached the zip'ed file for review. There may be some broken formulas on other sheets as I removed the actual order data and copied some formula results to data, but the pivot table in question is based on the data in the "Weekday" sheet. Also, please ignore the "dead" macro buttons, I stripped the macros out for security, but didn't go through and delete all the buttons. I am specifically looking at the chart and table on "Weekday Chart," but the issue prevails in ANY of my workbooks that contain Pivot Tables/Charts that have more than 1 year of data.

Thanks in advance.