Filter Excel Pivot Table

Hi, I am working on a project where the trust setting is by default disabled in the company, thus, I am not able to use the invoke VBA activity to filter the pivot table. May I know if there is a way for me to perform a filter to deselect some items in the pivot table?

Kindly assist urgently. Thank you.

Hi @ngweijie97
you can use customize package activity to do this.

In that case instead of doing the pivot using the default activities you can use the linq approach for pivot

HI @ngweijie97

Have a look on the video Link


Hi, I tried, but it’s not working…