Excel Pivot Table - filter value

Help Activities
, ,
1

Hi

can you help me with syntax?
I need to filter only rows with “Value” is “Yes”:

image
image570×551 17.7 KB

Thx. KR, Vanja

2

@VanjaV,

After Creating Pivot, you will have to use Filter Pivot Table activity to filter the Pivot table like this.

image
image456×174 8.85 KB

Sample:

This image shows a workflow in an Excel Process Scope where an Excel file named "input.xlsx" is used to create a Pivot Table from data on "Sheet1" and place it on "Sheet2" with specified field configurations, followed by applying a filter on the "Status" column of the Pivot Table. (Captioned by AI)
This image shows a workflow in an Excel Process Scope where an Excel file named "input.xlsx" is used to create a Pivot Table from data on "Sheet1" and place it on "Sheet2" with specified field configurations, followed by applying a filter on the "Status" column of the Pivot Table. (Captioned by AI)594×1282 49.2 KB

3

Thx, @ashokkarale :slight_smile:

it worked after I defined the Field in Create Pivot Table as a Filter.

image
image620×459 13.8 KB

KR, Vanja