How to configure filter pivot table

[Rakesh_Tiwari]

Hi All,

i want to filter pivot table and there are two pivot table in my case.

my requirement is i want to filter for two columns, how to configure in colimn name, if i am selecting other column name first one goes off?
Also, how to use configure filter option, i wnat to remove blanks which are coming in pivot table.

Thanks
Rakesh

[ashokkarale]

@Rakesh_Tiwar,

@Rakesh_Tiwari

want to filter for two columns

You will have to use two Filter Pivot Table activities

@Rakesh_Tiwari

if i am selecting other column name first one goes off?

No it will not go off until and unless you checkbox the Clear any existing filter checkbox.

@Rakesh_Tiwari

i wnat to remove blanks which are coming in pivot table

pass String.Empty in filter value.

Try this way sample.

Sample code:
Workflow1.xaml (10.9 KB)

Thanks,
Ashok

[Rakesh_Tiwari]

Hi @ashokkarale ,

Thanks for the reply.

is this expression wrong? throwing error - Filter Pivot Table: PivotFields method of PivotTable class failed

[Rakesh_Tiwari]

Hi @Anil_G ,

may i have you input?

Thanks

[ashokkarale]

@Rakesh_Tiwari ,

No need of round bracket.

Just String.Empty

[Rakesh_Tiwari]

it doesn’t work @ashokkarale

[ashokkarale]

any error or output?

[Rakesh_Tiwari]

Filter Pivot Table: PivotFields method of PivotTable class failed