Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-31-2020, 03:05 PM
wheddingsjr wheddingsjr is offline Why does the total row of my pivot table not tie to the real count using distinct count Windows 7 64bit Why does the total row of my pivot table not tie to the real count using distinct count Office 2016
Advanced Beginner
Why does the total row of my pivot table not tie to the real count using distinct count
 
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
  #2  
Old 08-31-2020, 10:22 PM
Purfleet Purfleet is offline Why does the total row of my pivot table not tie to the real count using distinct count Windows 10 Why does the total row of my pivot table not tie to the real count using distinct count Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Distinct is counting the number of unique numbers in your main data - there are 19 unique numbers in your data
Attached Images
File Type: jpg pivdist.jpg (74.9 KB, 16 views)
Reply With Quote
  #3  
Old 08-31-2020, 10:31 PM
wheddingsjr wheddingsjr is offline Why does the total row of my pivot table not tie to the real count using distinct count Windows 7 64bit Why does the total row of my pivot table not tie to the real count using distinct count Office 2016
Advanced Beginner
Why does the total row of my pivot table not tie to the real count using distinct count
 
Join Date: Mar 2017
Posts: 76
wheddingsjr is on a distinguished road
Default

Thanks Purfleet..I totally understand that, the question, I guess, is why wouldn't the grand total reflect that?
Reply With Quote
  #4  
Old 08-31-2020, 10:40 PM
wheddingsjr wheddingsjr is offline Why does the total row of my pivot table not tie to the real count using distinct count Windows 7 64bit Why does the total row of my pivot table not tie to the real count using distinct count Office 2016
Advanced Beginner
Why does the total row of my pivot table not tie to the real count using distinct count
 
Join Date: Mar 2017
Posts: 76
wheddingsjr is on a distinguished road
Default

I take that back, the grand total DOES reflect that, however, when manually adding the column, its more than that. Is that irrelevant?
Reply With Quote
  #5  
Old 09-01-2020, 09:52 PM
Purfleet Purfleet is offline Why does the total row of my pivot table not tie to the real count using distinct count Windows 10 Why does the total row of my pivot table not tie to the real count using distinct count Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

The difference is because of the categories - there are 19 unique numbers in the data, but there are 26 unique combinations of number with the L/M/S & colour added.

if you change the orange 13 to 11 in the main data it changes to 18 & 25.

It depends on what you are trying to count if it makes a difference
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why does the total row of my pivot table not tie to the real count using distinct count How can I count per year and per week the total number of times a code occurs Stefan_Deckers Excel 3 09-19-2020 02:36 PM
Why does the total row of my pivot table not tie to the real count using distinct count Getting the Count formula to count all rows Jennifer Murphy Word Tables 11 08-23-2016 09:37 PM
Count distinct entries only gebobs Excel 5 10-13-2014 06:30 AM
Why does the total row of my pivot table not tie to the real count using distinct count Word: count total page of each section salmonrose Word 1 10-15-2011 05:10 AM
Why does the total row of my pivot table not tie to the real count using distinct count How to count the total cells that contains text data? Learner7 Excel 1 06-30-2011 04:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:11 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft