Filter Excel Pivot Table

Help Activities
,
1

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.

3

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

4

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

5

HI @ngweijie97

Have a look on the video Link

Regards
Gokul

7

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