Forum Discussion

Brass Contributor

Feb 14, 2024

Solved

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 co...

BI & Data Analysis

excel

office 365

Namonpas
Feb 20, 2024
Thank you so much, Andrew!:)

Lorenzo

Silver Contributor

Feb 16, 2024

Andrew M

Sorry, forgot to mention this. Yes I did but after Excel "repaired" the file there was more Pivot:

Andrew M

Brass Contributor

Feb 16, 2024

Lorenzo No problem. Thanks for helping with this. I wonder why you weren't able to replicate the error. Maybe your build being 16.0 is why (yours is Version 2401 Build 16.0.17231.20194 64-bit, mine is Version 2401 Build 17231.20194 64-bit).

SergeiBaklan
Diamond Contributor
Feb 17, 2024
Andrew M

I reproduced that error on shared in this thread and new file, both on Current and Beta channels of Excel.

Bug, but if to use explicit measures, which is recommended practice, no problems with them.
Lorenzo
Silver Contributor
Feb 17, 2024
Andrew M

16.0 or not I don't think (not sure) this makes a difference. It might be - for whatever reason - they don't mention it in Enterprise subscription. With Enterprise - to my knowledge - your company is eligible to open a ticket at MSFT