+ Reply to Thread
Results 1 to 4 of 4

Pivot used to have a column label (blank), now just displays a less-than date field

  1. #1
    Registered User
    Join Date
    05-07-2024
    Location
    USA
    MS-Off Ver
    O365
    Posts
    2

    Pivot used to have a column label (blank), now just displays a less-than date field

    Several months ago, when grouping a pivot table by date (year), there would be a column labeled, "(blank)" that tallied all records that did not have a date listed.

    Now, that shows a date - e.g. "<8/31/2018" instead of "(blank)"

    Not sure when it changed, but is it possible to force the label to blank instead of a less-than date?
    Attached Images Attached Images

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,028

    Re: Pivot used to have a column label (blank), now just displays a less-than date field

    That happens if you group a date field. You should be able to overtype the value
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Registered User
    Join Date
    05-07-2024
    Location
    USA
    MS-Off Ver
    O365
    Posts
    2

    Re: Pivot used to have a column label (blank), now just displays a less-than date field

    Thanks for the reply. I guess the issue is that, several months ago, it automatically labeled that column as (blank), even grouping a date field. Somewhere in the past few months, that behavior has changed to now just show the less-than date... Wondering if there's a way to revert to showing that as blank without me manually typing in that cell each time.

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,028

    Re: Pivot used to have a column label (blank), now just displays a less-than date field

    Not that I'm aware of. I don't actually recall it ever having any other behaviour when grouping dates.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Pivot to show only Non-Zero/blank field and total for Column
    By jp16 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 08-29-2017, 08:27 AM
  2. Replies: 2
    Last Post: 08-22-2015, 07:45 AM
  3. Replies: 8
    Last Post: 07-25-2014, 06:06 AM
  4. [SOLVED] ODBC date field displays as 1/0/1900
    By mateoc15 in forum Excel General
    Replies: 2
    Last Post: 03-26-2014, 09:02 AM
  5. Replies: 1
    Last Post: 09-30-2013, 09:52 AM
  6. [SOLVED] How to delete column label from pivot table field
    By Evy Lum in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-27-2006, 09:15 AM
  7. How to set-up a field that displays the last updated date
    By teh_chucksta in forum Excel General
    Replies: 1
    Last Post: 07-14-2006, 08:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1