+ Reply to Thread
Results 1 to 2 of 2

Pivot table hide rows if all month values are NOT Empty, show if at least one BLANK.

  1. #1
    Forum Contributor
    Join Date
    03-12-2014
    Location
    Riyadh
    MS-Off Ver
    Excel 2013 Pro Plus
    Posts
    104

    Pivot table hide rows if all month values are NOT Empty, show if at least one BLANK.

    Hello friends, Hope all is well!

    I am going crazy please help.

    The image here is from a pivot table.
    I want to filter the row if all months are showing any values. if at least one month is blank I need it to appear.
    Please help us, how can it be done?

    please help us with a solution related to the pivottable, i.e. no formulas outside the pivot table, to minimize the manual adjustments.

    Thank you very very much in advance
    Attached Images Attached Images

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,751

    Re: Pivot table hide rows if all month values are NOT Empty, show if at least one BLANK.

    Short answer. You can't, using traditional Pivot alone.

    If using traditional pivot, with Sheet Range / Table as source. You'll need to add helper column in the source table to flag when to show data and when not to.

    If using Data Model based pivot. You can add calculated column and/or measure using DAX.
    1. Add calculated column. Then add it to slicer/filter for control.
    2. Add calculated column. Use that value as if condition in DAX measure. Making it return Blank() when condition not met. This will filter out data from pivot based on condition.

    There are other methods. But I'd recommend that you upload sample workbook, with desensitized data.
    To upload use "Go Advanced" button, follow "Manage Attachments" hyperlink. It will launch new tab/window for managing uploads.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

+ 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 TABLE - Hide Blank Rows
    By Rangerguy2000 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-02-2019, 12:09 PM
  2. Pivot table, show empty rows
    By Hein in forum Excel General
    Replies: 4
    Last Post: 02-17-2009, 06:15 AM
  3. How do I hide rows in a pivot table with zero values?
    By fs in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-22-2006, 04:15 PM
  4. How to show/hide range of Month on Pivot Table
    By kanley@rocketmail.com in forum Excel General
    Replies: 0
    Last Post: 01-09-2006, 02:55 PM
  5. Replies: 0
    Last Post: 11-02-2005, 06:20 PM
  6. Replies: 0
    Last Post: 11-02-2005, 06:17 PM
  7. [SOLVED] Do not show rows with no values in Pivot Table
    By Mark in forum Excel General
    Replies: 0
    Last Post: 04-19-2005, 02:06 PM

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