Hello,
could you please help me, with filter pivot table?
I have the whole process created, but I find that when I run it, it sometimes crashes on the pivot table filtering.
I always filter the same values, but sometimes it happens that the values I filter are missing in excel.
How to filter these values in the pivot table as easily as possible and if they are not included in excel, let it skip them?
For example:
I need to filter the rows from the SRCI column where the value “BGM1” is. In case this value is missing in the table today, I want to proceed to the next filter and skip this one.
Is it somehow easy to just check it somewhere in the settings? Or do you have to use a new activity in a complicated way? If so, does anyone have the best example of how I could do this please?
Thank you