Duplicate distinct counts in pivot tables corrupts files

Hello! I may have discovered a bug. I have a problem with pivot tables corrupting if I place a column of data into the values section of a pivot table twice and summarize both values as a distinct count. Has anyone else run into this? Do you know what root cause of this error is? How can I eliminate this error?

Some more detail:

I have had problems over the past week with normally stable Excel files becoming corrupt. If I click "Yes" when asked if I want to recover the file, I always receive a message that listing pivot tables that were removed.

Today, I noticed I can replicate this problem by placing a field into the "values" section of a pivot table twice and summarizing both of these value fields as a distinct count. I tested several permutations (two different fields but counted distinct, the same field placed as a value twice but only summarized as distinct count once, etc), but only the scenario listed produces an error.

I reproduced this error on three computers. Two coworkers had the same problem this week and were able to replicate the error following my steps. A friend at a different company replicated it as well.

My work around is to create a duplicate dummy column, place that alongside the first column into the pivot table (example, ItemID and ItemID_helper), then summarize both as distinct counts. However, I want to understand and solve the root cause of the problem to prevent errors in other existing spreadsheets containing pivot tables built this way.

If you’re wondering why I have duplicate distinct columns, column one displays the count as is, column two displays as a percent to total. Example, warehouse one has 34 unique customers which is 67% of total unique customers.