Pivot Table Date Issue

tomohawk · #1 02-01-2022, 10:48 AM

Oh OK - good top know.

Any idea why I am getting the other info in the drop-down.

Also, any idea how to get rid of blank rows?

Tommy

p45cal · #2 02-02-2022, 06:20 AM

Quote:

Originally Posted by tomohawk

Any idea why I am getting the other info in the drop-down.

That's just the way it is.

Quote:

Originally Posted by tomohawk

Also, any idea how to get rid of blank rows?

What blank rows? Usually you can filter out (blanks).

tomohawk · #3 02-02-2022, 06:52 AM

Please see attached

spillerbd · #4 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