Hello,
Been poking around on this board and the web for the past hour trying to find out if this is even possible... started to give up, but thought I'd ask the experts first.
Is there a way to filter data in a pivot table using an or function instead of an and function, e.g. I have a standard pivot table with two fields in the report filter section. I'd like to set up the table so that it pulls all data where Field A = X or Field B = X, not Field A and B are = X.
Any help you can provide would be much appreciated. The data set will subsequently be updated by novices (more so than me), so I'm hoping there's a simple solution with a pivot table where I can just instruct them to update the data and hit refresh.
Many thanks in advance!
Been poking around on this board and the web for the past hour trying to find out if this is even possible... started to give up, but thought I'd ask the experts first.
Is there a way to filter data in a pivot table using an or function instead of an and function, e.g. I have a standard pivot table with two fields in the report filter section. I'd like to set up the table so that it pulls all data where Field A = X or Field B = X, not Field A and B are = X.
Any help you can provide would be much appreciated. The data set will subsequently be updated by novices (more so than me), so I'm hoping there's a simple solution with a pivot table where I can just instruct them to update the data and hit refresh.
Many thanks in advance!