Results 1 to 5 of 5

Fill in blanks in pivot table

This is a discussion on Fill in blanks in pivot table within the Excel Questions forums, part of the Question Forums category; Hello! Excel 2007 Any idea how to fill in blanks in the vertical axis of a pivot table? I know ...

  1. #1
    Board Regular
    Join Date
    Aug 2005
    Location
    Dallas, TX
    Posts
    193

    Default Fill in blanks in pivot table

    Hello!

    Excel 2007

    Any idea how to fill in blanks in the vertical axis of a pivot table? I know how to handle empty cells in the main portion of the pivot table - but can't seem to figure it out for the row labels.

    Thanks for any info.

  2. #2
    Board Regular
    Join Date
    Feb 2007
    Location
    England
    Posts
    3,244

    Default Re: Fill in blanks in pivot table

    Any idea how to fill in blanks in the vertical axis of a pivot table? I know how to handle empty cells in the main portion of the pivot table - but can't seem to figure it out for the row labels.
    That's the way PTs are designed. You do not see repeated values as it's 'easier' to read things without them.

    Matty

  3. #3
    Board Regular
    Join Date
    Aug 2005
    Location
    Dallas, TX
    Posts
    193

    Default Re: Fill in blanks in pivot table

    I recognize that... however I need to do a nested Vlookup using the data in this pivot, and can't if the field is blank.

    Unless there is some other way to do the vlookup?

  4. #4
    Board Regular
    Join Date
    Feb 2007
    Location
    England
    Posts
    3,244

    Default Re: Fill in blanks in pivot table

    I'm sure there's something we can do.

    Can you provide an example of how your PT is laid out as well as what you're trying to lookup? Actual data (doesn't have to be real) rather than a screen shot would be best.

    Matty

  5. #5
    Board Regular tweedle's Avatar
    Join Date
    Aug 2010
    Location
    35.883348,-78.510216
    Posts
    1,555

    Default Re: Fill in blanks in pivot table

    Maybe....



    Right Click, Field Settings
    Go to the Layout & Print tab
    'check' the Show items with no data
    Win7::MSO2007
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    I have no special talent.
    I am only passionately curious. - Albert Einstein
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    "Simple" and "Easy" are a matter of perspective
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Solutions here may be 'representative' and you may
    need to actually put some thought to your own needs.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com