+ Reply to Thread
Results 1 to 2 of 2

PIVOT CHART grouping with Date

  1. #1
    Registered User
    Join Date
    05-14-2019
    Location
    Nova Scotia, Canada
    MS-Off Ver
    2013
    Posts
    1

    PIVOT CHART grouping with Date

    Hi I am having issues grouping a pivot table from days to months. I know the issue is due to blank cells, however I am looking for a work around. here is an example of the workbook:

    A1 contains a date (manually added)
    B1 contains following formula: =IF(ISBLANK(A01),"",TODAY()-A01)
    C1 contains following formula: =IF(ISBLANK(A01),"", A01+B01)
    D1 contains Yes or No values.

    I want to create a pivot table, that shows # of Yes or No grouped by month. I understand that is it the blank cells and the "", that is causing the issues.

    Anyone have any suggestions on how to get the grouping to month or to force the pivot to ignore the blank cells?

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    6,952

    Re: PIVOT CHART grouping with Date

    Without seeing the workbook, I can only give a vague suggestion: add a helper column with the formula =ISBLANK(DateCell) and then use this as a filter for the pivot table with the value FALSE.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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