+ Reply to Thread
Results 1 to 2 of 2

Pivot table hide rows with no data in values

  1. #1
    Registered User
    Join Date
    03-20-2009
    Location
    Lithuania
    MS-Off Ver
    Excel 2013
    Posts
    99

    Pivot table hide rows with no data in values

    Is it possible to hide rows, where there are no data in values (values are empty)? Here is an example of my Pivot. I marked rows, which I would like to hide, in red, and rows, which I would like to be visible, in green.
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Pivot table hide rows with no data in values

    Can you, please, attach a sample workbook?
    Diana Tanase


    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !

+ 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 table hide rows if all month values are NOT Empty, show if at least one BLANK.
    By saudi_red_neck in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-25-2019, 11:02 AM
  2. [SOLVED] Macro to hide rows in pivot table if values in row C&D are both 0
    By nhouse20 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-18-2012, 10:09 AM
  3. Hide pivot table rows with certain data values
    By NMullis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2008, 09:22 AM
  4. [SOLVED] 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
  5. Pivot Table - How to hide all rows which is 0
    By Ctech in forum Excel General
    Replies: 2
    Last Post: 05-03-2006, 08:56 AM
  6. [SOLVED] How do i hide rows in pivot table that has zero values?
    By SHIAN in forum Excel General
    Replies: 0
    Last Post: 11-02-2005, 06:20 PM
  7. [SOLVED] How do i hide rows in pivot table that has zero values?
    By SHIAN in forum Excel General
    Replies: 0
    Last Post: 11-02-2005, 06:17 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