Thread: [Solved] Why does the total row of my pivot table not tie to the real count using distinct count
View Single Post
 
Old 09-01-2020, 09:52 PM
Purfleet Purfleet is offline Windows 10 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