Results 1 to 3 of 3

Add column to pivot to hide rows...

Threaded View

  1. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,658

    Re: Add column to pivot to hide rows...

    One way:

    1. Insert a table of one column directly to the RIGHT of the PT.
    2. Poplulate rows that are complete with Y.
    3. Use the table's filter to hide columns containing Y (you could add a slicer, of course).

    Would this work for you?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot Hide Rows With (blank) In Row Label
    By goss in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-22-2014, 08:55 AM
  2. Pivot filters to hide certain rows
    By Hanskubansku in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-30-2012, 11:32 AM
  3. Replies: 1
    Last Post: 01-25-2012, 04:29 AM
  4. Pivot Table total rows hide?
    By EnergyEngineer in forum Excel General
    Replies: 3
    Last Post: 04-29-2008, 02:56 PM
  5. Hide rows between 2 pivot tables if they are empty
    By Richard Flame in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-30-2007, 02:07 PM
  6. 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
  7. Replies: 0
    Last Post: 11-02-2005, 06:20 PM
  8. 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