+ 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
    7,056

    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)

Similar Threads

  1. Pivot Chart Date Grouping
    By Fenrir1016 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-17-2018, 10:05 AM
  2. Two products on a Single date, Pivot date grouping through gaps
    By Rajendra_kodavaty in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-04-2016, 09:47 PM
  3. Replies: 1
    Last Post: 07-22-2015, 07:16 AM
  4. [SOLVED] Creat grouping count values in Pivot Chart
    By timko92 in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 04-13-2014, 04:59 PM
  5. problem grouping dates in Pivot chart in Excel 2010
    By briano42 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-27-2014, 12:26 AM
  6. Pivot Table / Chart not grouping same entries
    By bigpee in forum Excel General
    Replies: 4
    Last Post: 02-05-2010, 10:52 AM
  7. Grouping data in Pivot chart
    By ChemistB in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-24-2009, 10:53 AM

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