I have to add multiple criteria to page field filter filters in the pivot table for that i am using Excel Extended VBO.
When i used multiple action it replace first criteria and add the new filter for pivot.
So how we can add multiple criteria to pivot filter field?
Thanks in advance.
------------------------------
Tejashri Nevase
------------------------------
This is code stage i am using. I used the same as you show.
------------------------------
Tejashri Nevase
------------------------------
I just change the input name as Column_Name And Pivot_Table_Name as Column Name and Pivot Table Name in your input. All I just follow all your instruction
And also copy your code as same.
I will share criteria collection . as I add field as 'Criteria Name' and add Two criteria.
------------------------------
Tejashri Nevase
------------------------------
I will work fine with the number criteria.but it throw the error when i pass the character in the criteria collection.
This is working fine.
But when i pass the above criteria collection i got the same error as above.
Why this is happening.? Is there need to change the code for Character?
Thanks
------------------------------
Tejashri Nevase
------------------------------
Hi Tejashri,
I have checked with the characters as well and it works. You are passing the wrong column number most likely and hence this issue is coming up. Check the below results for your reference:
As you can see in my pivot I made a small change where I am taking the Employee Name as a filter this time and passing the appropriate criteria for the same as well. But since I am taking employee name as a filter, my column position will change from 1 to 2 since it is the second column in my original worksheet:
As you see here, my criteria values should consist of the values among the available values for that column in my original dataset for which I wish to put on the filter along with the column position also where it lies exactly. Since, I want to filter on Employee Name and that is the second column in my original dataset. I will provide the column position as 2 and values also will be among the values that are present in that column only.
Like I was saying before, you can show us the original data and the column number that you are passing for me to troubleshoot it for you.
------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future
Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com
----------------------------------
------------------------------
