Can't set multiple criteria to the filter of Pivot table

[HongJooChoi]

Hi, Community

I need your help.

How can I set multiple criteria to the filters of Pivot Table? (I'm using MS Excel VBO - Extended)

It was confirmed that "Add Criteria to Page Field Filter for Pivot Table" does work for adding one filter criteria, but couldn't find the way to set multiple criteria for the filter.  Should I set the "Criteria" parameter with a certain syntax or Should use another action which I couldn't find?

Regards

------------------------------
HongJoo Choi
------------------------------

[harish.m · Accepted solution]

Hi HongJoo Choi,

You can achieve it by creating new action in MS Excel VBO extended and update teh code stage. Check below thread. 

https://community.blueprism.com/discussion/about-multiple-filter-in-pivot-table#bm248935c0-786b-4fec-9c91-5ab74c3171d5

------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish M
Lead developer
America/New_York TX
------------------------------