|
|
#10
02-05-2022, 11:17 PM
|
|||
|
|||
The Pivot Table is going to show all the data from the selected range. The items that are showing without any values are listed in your data set without any values.
A mindset for the Database, or any data set to reduce waste, is that only records with data are recorded. Those rows are incomplete and, for some, not appropriate to be included in the dataset. Also, there is a difference between 0 (zero) and NULL (no records.) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Issue With Date In Pivot Table
|
tomohawk | Excel | 6 | 01-18-2022 08:42 AM |
|
Pivot table dates issue
|
salse | Excel | 1 | 06-08-2016 12:23 PM |
| Excel pivot table with a DATE value field for some reason stops at a certain date | angie450 | Excel Programming | 2 | 08-19-2014 08:50 AM |
|
Pivot Table issue
|
ominae | Excel | 1 | 07-18-2014 01:40 AM |
| Pivot Table Issue | Grovesy | Excel | 0 | 10-28-2012 09:08 PM |
Windows 10 
Office 2013
Threaded Mode