Hi there, I’m currently working to create a pivot table to pull data. This pivot table is being created using order form data.
In this form, every column has a different title. ex: name, order number, quantity, etc.
However, TBD is a possible selection for every column. For example, date order is needed by can be selected as TBD, as well as other form fields such as color can be selected as TBD. I would like a pivot table to filter if TBD is selected for any field to display the order information. However I am struggling to display orders that have tbd selected anyone, because some rowa have tbd in multiple locations, while sometimes TBD Is in just one area.
bascially, the condition I am looking to add into this pivot table is that is TBD is present anywhere, it needs to be flagged. If TBD is not present anywhere in the row, it does not need to be in the pivot table.
How can I do this?
