Hi All,
When I use Pivot Table, I place 2 filters let's say it's filter A and B. When I choose the data "x" for filter A and data "y" for filter B, I see that the result is the data which has data "x" AND "y". The problem is, I need to see the data of "x" OR "y" displayed. Can I achieve this using Pivot Table? Right now I can only achieve this using Advanced Filtering but it will be more comfortable to look at it in Pivot Table.
Any help and advice is much appreciated. Thank you.
When I use Pivot Table, I place 2 filters let's say it's filter A and B. When I choose the data "x" for filter A and data "y" for filter B, I see that the result is the data which has data "x" AND "y". The problem is, I need to see the data of "x" OR "y" displayed. Can I achieve this using Pivot Table? Right now I can only achieve this using Advanced Filtering but it will be more comfortable to look at it in Pivot Table.
Any help and advice is much appreciated. Thank you.