topic Can't set multiple criteria to the filter of Pivot table in Digital Exchange https://community.blueprism.com/t5/Digital-Exchange/Can-t-set-multiple-criteria-to-the-filter-of-Pivot-table/m-p/50280#M224 <P>Hi, Community</P> <P></P> <P>I need your help.</P> <P></P> <P>How can I set multiple criteria to the filters of Pivot Table? (I'm using MS Excel VBO - Extended)</P> <P><span class="lia-inline-image-display-wrapper" image-alt="5929.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/6109i5EA5E00DA2422265/image-size/large?v=v2&amp;px=999" role="button" title="5929.png" alt="5929.png" /></span></P> <P></P> <P>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.&nbsp; Should I set the "Criteria" parameter with a certain syntax or Should use another action which I couldn't find?</P> <P></P> <P>Regards</P> <P></P> <P></P> <P></P> <P></P><BR /><BR />------------------------------<BR />HongJoo Choi<BR />------------------------------<BR /> Wed, 26 Jul 2023 00:45:00 GMT HongJooChoi 2023-07-26T00:45:00Z Can't set multiple criteria to the filter of Pivot table https://community.blueprism.com/t5/Digital-Exchange/Can-t-set-multiple-criteria-to-the-filter-of-Pivot-table/m-p/50280#M224 <P>Hi, Community</P> <P></P> <P>I need your help.</P> <P></P> <P>How can I set multiple criteria to the filters of Pivot Table? (I'm using MS Excel VBO - Extended)</P> <P><span class="lia-inline-image-display-wrapper" image-alt="5929.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/6109i5EA5E00DA2422265/image-size/large?v=v2&amp;px=999" role="button" title="5929.png" alt="5929.png" /></span></P> <P></P> <P>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.&nbsp; Should I set the "Criteria" parameter with a certain syntax or Should use another action which I couldn't find?</P> <P></P> <P>Regards</P> <P></P> <P></P> <P></P> <P></P><BR /><BR />------------------------------<BR />HongJoo Choi<BR />------------------------------<BR /> Wed, 26 Jul 2023 00:45:00 GMT https://community.blueprism.com/t5/Digital-Exchange/Can-t-set-multiple-criteria-to-the-filter-of-Pivot-table/m-p/50280#M224 HongJooChoi 2023-07-26T00:45:00Z RE: Can't set multiple criteria to the filter of Pivot table https://community.blueprism.com/t5/Digital-Exchange/Can-t-set-multiple-criteria-to-the-filter-of-Pivot-table/m-p/50281#M225 <P>Hi <SPAN>HongJoo Choi,</SPAN></P> <P><SPAN></SPAN></P> <P>You can achieve it by creating new action in MS Excel VBO extended and update teh code stage. Check below thread.&nbsp;</P> <P></P> <P><A href="https://community.blueprism.com/discussion/about-multiple-filter-in-pivot-table#bm248935c0-786b-4fec-9c91-5ab74c3171d5" target="test_blank">https://community.blueprism.com/discussion/about-multiple-filter-in-pivot-table#bm248935c0-786b-4fec-9c91-5ab74c3171d5</A></P><BR /><BR />------------------------------<BR />-----------------------<BR />If I answered your query. Please mark it as the "Best Answer"<BR /><BR />Harish M<BR />Lead developer<BR />America/New_York TX<BR />------------------------------<BR /> Wed, 26 Jul 2023 01:46:00 GMT https://community.blueprism.com/t5/Digital-Exchange/Can-t-set-multiple-criteria-to-the-filter-of-Pivot-table/m-p/50281#M225 harish.mogulluri 2023-07-26T01:46:00Z