+ Reply to Thread
Results 1 to 4 of 4

Pivot Group Dates - how to remove start and end dates from table

  1. #1
    Registered User
    Join Date
    03-09-2009
    Location
    World
    MS-Off Ver
    Excel 2003
    Posts
    6

    Pivot Group Dates - how to remove start and end dates from table

    Hi,

    I group a date field into months, quarters and years .
    When I use this field in a pivot table the first and last date options are the<Starting with date and the >ending date.
    I do not want the starting date and ending date in the table.

    How do I get rid of the satrt and end dates from the table. If I unselect the end date from the filter I miss a good bit of that months data from the report.

    The attachment shows the starting with date in the table which I do not want.

    When I group the date field checking or unchecking the starting and ending dates do not make a difference.
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    03-09-2009
    Location
    World
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Pivot Group Dates - how to remove start and end dates from table

    The date field contains both the date and the time. The time will be different for all entries.

  3. #3
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Pivot Group Dates - how to remove start and end dates from table

    deselect the start date from the list of items shown in the column field dropdown
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  4. #4
    Registered User
    Join Date
    03-09-2009
    Location
    World
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Pivot Group Dates - how to remove start and end dates from table

    I found that if I deselect the auto end date and set it to 2020 it gets me past the issue (for now at least).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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