Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Why does the total row of my pivot table not tie to the real count using distinct count Why does the total row of my pivot table not tie to the real count using distinct count
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
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

« Previous Thread | Next Thread »


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 05:33 AM.

Contact Us - Privacy Statement - Top

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