Excel Pivot Filter how to uncheck blank data

I am using Studio X
Hi everyone I am using the excel pivot filter and I can’t find a way to uncheck the blank data in pivot beside using clicking is there a another possible way to uncheck the blank data in pivot filter??

@flashdrive07

Did you happen to try this?

https://docs.uipath.com/activities/other/latest/productivity/filter-pivot-table-x

Try with Type.Missing in the filter

Cheers

do you have sample vb expression for this?

@flashdrive07

this is hoe it looks…

as pivot does not have not equals you can filter on all the values in required column leaving blank

cheers

Hello @flashdrive07

  1. Add “Set Filter” Activity to your StudioX workflow.

  2. Configure the “Set Filter” Activity:

    • Indicate the pivot filter you want to modify by selecting it in Excel.
    • Choose the filter criteria (e.g., “equals” or “does not equal”).
    • Set the filter value to “blank” or specify the value you want to exclude.
  3. Run your StudioX workflow.

  4. The “Set Filter” activity will programmatically uncheck the blank data in the pivot filter.

Thanks & Cheers!!!

Hi @Kartheek_Battu

this is the sample image of pivot filter “does not equal to is not available in pivot filter”
image

@flashdrive07

Please try the above

Cheers

@Anil_G
Hi sorry for the late notice…

I already tried it but it checks the current row.
displays the data per current row.

the automation must uncheck the “blank” in the pivot filter.

@flashdrive07

If you dont clear the filter and use for each row ideally it should check all the data and not inly one

Can you please confirm the same

Cheers

@Anil_G
this is the output of the filter

image

Hi, did you manage to solve the problem? I have something similar that bothers me. after filtering the pivot table where only one data is enough, I was left with a column named blank that I don’t want there.

no,… I just used click and shortcut keys to uncheck the blank column

yes, that’s a possibility. but will it then be possible to start this automation on unattended? I would also use a simple click, but this put me off.