Announcement

Collapse
No announcement yet.

Don't Show Blank Pivot Table Fields in Drop-downs

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Don't Show Blank Pivot Table Fields in Drop-downs



    Hi all,
    I am creating a pivot table from region, which some of the rows are blank.
    Is there any possibility that the pivot table not show the blank in its dropdown combobox?

  • #2
    Re: Pivot Table

    tanha, POOR THREAD TITLE Please read THIS PAGE IN FULL

    I will edit it this time, but next time your post will be deleted.

    Comment


    • #3
      Re: Pivot Table

      thanks for editing the TITLE...

      I found the Solution,
      I named the Region which was needed for pivot table, then the Blank word not appears in dropdown of pivot table field...

      Comment


      • #4
        Re: Don't Show Blank Pivot Table Fields in Drop-downs

        tanha, Thanks for sharing your solution with us.
        .

        Comment


        • #5


          Re: Don't Show Blank Pivot Table Fields in Drop-downs

          Thanks too.
          Actually I found the solution from this forum, unfortunatly I forgot the correct link, so I put the file I downloaded from here...all Rights and Thanks are for the one who made this
          Attached Files

          Comment

          Working...
          X