Hello,
I am creating a pivot table in Excel using data that has more than 50k rows. I use Filter Pivot table activity to only get certain criteria. That all works fine. I am having trouble deselecting a couple of options from a different filter. I used Invoke VBA and I keep getting an error. The file is .xlsx; I have changed it to .xlsm and that still does not help.
I tried filtering the data table before I create the pivot and the information is not correct, plus the read range takes so long since it is large data.
Does anyone have any suggestions on how I can uncheck a couple of options in my pivot table filter?
Did you try with this activity?
https://docs.uipath.com/activities/other/latest/productivity/filter-pivot-table-x
Cheers
Hello,
I use that activity when I only have a few options to keep. How can I use it when I only want to deselect or uncheck a few options?
I am getting an error when using contains
Please give only "GTL_USA"
and filter in excel has contains and not the pivot
you want to do a contains only?
cheers
There are only 2 items I want to not include in this table. what expression can I use to not include those items? The other items that are included are dynamic and are at least 20 or more items. Please help me with the below expression?
Try with filter
If not we need to go with vba
ActiveSheet.PivotTables("PivotTable4").PivotFields("Traders Name")
.PivotItems("GTL_USA").Visible = False
.PivotItems("XYZ").Visible = False
cheers
the filter activity is still not unchecking the two option in the pivot table. Also, I used VBA and used an invoke vba activity and was getting an error.
Here is my filter activity. I use it after the pivot:
Any suggestions?
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.