Hello,
Could someone tell me what do I need to do if a filter is not present in the current pivot table? When I configure the filter one by one, it filters correctly. but if the filter is not there, it throws an error: “Filter value(s) not found on the field” and does not filter the ones that are found. is there a way to use the filter pivot activity with CONTAINS or is there another way to filter the pivot for the ones that are on the pivot table?
I would like to update this ask: I want to save the filter values in an excel file. Read the values, store as a variable and filter the pivot with the variables. I also, need a condition if the filter value is not present in the pivot - because sometimes it will be present, sometimes it will not.
I searched the forum and could not find anything for this. Any suggestions? thank you
Thank you for your response.
Just to make sure I understand. Your condition looks at a certain column in datatable for a certain value and if true, it filters pivot table?