Removing a blank label from Pivot Table.

[Livin404]

Good evening, I'm a little stuck with my pivot table. With help from this group I was able to separate Country Codes with State Codes based on a three letter code in another cell. Now unfortunately, the table is totaling the sums that are identified as a number belonging to a state. In the example, you see label that is nothing that has nothing in it, yet the quantity is the total of the passengers I have marked for the states. In the design mode turned off all total, and unchecked the box on the filter, but that doesn't last.

I'm hoping this can be done without VBA.

Thank you,

 

[igold]

I am not real clear on what you are asking, but in the pic you have posted, 1702 is not the sum of the numbers shown above it...

 

[Livin404]

I am not real clear on what you are asking, but in the pic you have posted, 1702 is not the sum of the numbers shown above it...

The number does not suppose to be the total. One column has countries and another has states. The column that has the number of passengers is the same column for both the country and state. The 1702 is the number total of passenger for the states. I do not want the last row showing in the table.

 

[Alex Blakenburg]

From your previous posts, you have an empty string "" in that field of the data.
You can try excluding it from your pivot by using a Label Filter on that field and putting Greater Than " " (without the quotes ie just a space).
You could also deselect the blank from the list of items but the pivot would then not automatically pick up any new Country codes that are added.

 

[Livin404]

Thank you, I had originally used "blank", and of course I tried the multi-filter which I couldn't because I wanted two label filters. I tried yours and it took care of both of them.

Thank you so much!

 

[Alex Blakenburg]

Thanks for letting us know. Glad we could help.