PivotTable filter

Help Something Else
1

Hi All,

Can we filter the Pivot table using UiPath ?
This image shows a pivot table summarizing error details with counts, highlighting errors such as missing stamped agreements and a plant not found in the system, along with their occurrence numbers. (Captioned by AI)

2

Hi @Pavan_kumar15

Use Filter Pivot Table activity

image

Regards,

3

@lrtetala in Source–>do i need to give new pivot table name ?

4

@Pavan_kumar15

Yes, you need to give Pivot Table Name

The image shows a dialog box for filtering a pivot table in Excel, specifying "Sheet2" and "Pivot1" as the source and "ErrByOp1(ErrByOp1)" as the column name. (Captioned by AI)

This image shows the configuration interface for filtering a pivot table in an Excel automation process, with options to select the source sheet and pivot table highlighted. (Captioned by AI)
This image shows the configuration interface for filtering a pivot table in an Excel automation process, with options to select the source sheet and pivot table highlighted. (Captioned by AI)1095×240 35.2 KB

5

@lrtetala Thanks a lot!! it worked well

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.