Filter pivot table activity - studio X

Help Activities
, ,
1

with this activity, how do i filter pivot table with the condition (NOT equal to blank)
without using VBA

image
image668×593 24.6 KB

2

Hi @jack.chan

choose operator “does not equal”. leave value empty to filter out blanks. this filters pivot table where values are not blank

If helpful, mark as solution. Happy automation with UiPath

3

@jack.chan

The image is of a text-based guide explaining how to configure an activity, detailing steps for selecting a source, column name, configuring a filter, and clearing existing filters. (Captioned by AI)
The image is of a text-based guide explaining how to configure an activity, detailing steps for selecting a source, column name, configuring a filter, and clearing existing filters. (Captioned by AI)757×416 51 KB

4

theres no “does not equal” operator, see the screenshot theres only "is equal to“ :laughing: