Forum Discussion
Solved
OR function in pivot table
Spoiler
Spoiler
I'm working with a pivot table for a data set that has multiple columns of text entries. I want to specify entries within each column, then filter using OR, rather than the default which seems to be AND. How can that be done?
That's not an option in PivotTable user interface. You may add calculated field or calculated column and filter on it.
3 Replies
That's not an option in PivotTable user interface. You may add calculated field or calculated column and filter on it.
Aw, sorry to learn that! But thank you for your help, Sergei, it saves me time in searching.
Dennis_W130 , you are welcome
