+ Reply to Thread
Results 1 to 2 of 2

Pivot Table tree structure - hide blank branches

  1. #1
    Registered User
    Join Date
    07-16-2014
    Location
    Ontario
    MS-Off Ver
    2011
    Posts
    3

    Pivot Table tree structure - hide blank branches

    Pretty much the same issue as: https://www.excelforum.com/excel-gen...nk-leaves.html

    I have a log where each row represents an event with a hierarchy of items, and the hierarchy is parsed into the columns of the "Log Data" table.
    The hierarchy is then reported in a Pivot Table, with each level of the hierarchy in the Rows field.

    However, not every event log has a full hierarchy. Some events have only a 3-level hierarchy, some have the full 6, and all possibilities in between.
    As a result, the Pivot Table is showing blanks in the tree structure.

    The goal is to hide the blanks (highlighted orange in attached file) completely, and have the parents with blanks (highlighted green in attached file) show no tree button and not be expandable. I can't hide (blank) using the filter, since this eliminates the parent levels as well. Example: filtering out (blank) from B1 or C1, completely removes them both leaving only A1.

    Example of the goal is next to the Pivot Table in attached file.

    Is this possible?
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-05-2018
    Location
    Moscow
    MS-Off Ver
    365
    Posts
    1

    Re: Pivot Table tree structure - hide blank branches

    Hello, have you solved the issue?

+ 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. How to expand and collapse (unhide and hide) rows in a tree like structure
    By Scott N in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-21-2013, 05:57 PM
  2. Tree Structure with +/- button
    By meatballv10 in forum Excel General
    Replies: 4
    Last Post: 12-13-2012, 11:10 AM
  3. Extensive Tree Structure
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-24-2010, 09:10 AM
  4. hide blank cell pivot table
    By verisme in forum Excel General
    Replies: 8
    Last Post: 02-21-2010, 09:40 AM
  5. Hide blank or zero cells in PIVOT table
    By MarijaPL in forum Excel General
    Replies: 1
    Last Post: 11-02-2007, 11:10 AM
  6. [SOLVED] hide (blank) in pivot table
    By Nynke in forum Excel General
    Replies: 1
    Last Post: 06-12-2006, 01:15 PM
  7. Pivot Table - hide blank cells
    By Kirk P. in forum Excel General
    Replies: 1
    Last Post: 08-17-2005, 10:04 PM
  8. Tree Structure
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-24-2005, 11: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