Pivot Table - Filter in List Fields

vRibeiro

New Member
Joined
Nov 30, 2005
Messages
1
Hello,

I wanna soluction my need that i couldn't alone.
My need is that i have a simple pivot table just with Page Field and List Field, and I have to make a Filter that show me the datas that attend and union filter by "OR" not by "AND"

For eg. I have the list field NAME and the other list field PHONE, i would like that the pivot table show me the data who are Empty in NAME or in PHONE.

If I select the Empty for both, the pivot table understand like have to be Empty in NAME and in PHONE.

Thanks,
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Watch MrExcel Video

Forum statistics

Threads
1,118,726
Messages
5,573,842
Members
412,553
Latest member
sfay
Top