Thread: [Solved] Why does the total row of my pivot table not tie to the real count using distinct count
View Single Post
 
Old 08-31-2020, 03:05 PM
wheddingsjr wheddingsjr is offline Windows 7 64bit Office 2016
Advanced Beginner
  
Join Date: Mar 2017
Posts: 76
wheddingsjr is on a distinguished road
Default Why does the total row of my pivot table not tie to the real count using distinct count
Hi all

I am really confused. I made a pivot table and used "distinct count", In doing so, I get a total for the count but it doesn't tie if I added up all the rows manually. Its like the total is the distinct total, but the rows are not. Any opinions would be greatly appreciated. I am adding an attachment for an example.

Thanks
Attached Files
File Type: xlsx Book3 (3).xlsx (87.8 KB, 9 views)
Reply With Quote