Filter Pivot Table not working properly

Feedback Activities
,
1

I have a Pivot Table sheet and I’m using the “Filter Pivot Table” activity to filter a selected value. The activity works, but the filter value name is not visible in the Excel Pivot Table.

Alternatively, we use the click activity-clicking the filter icon and then clicking OK—and then the filter name is displayed.

Below, I have mentioned how the bot provides the output and how I want it to be.

Please help me out or anyone facing same issue.
@loginerror , @marian.platonov

Bot Output:

The image shows a pivot table in a spreadsheet application, structured to summarize net amounts categorized by companies with filters for handlers and tasks. (Captioned by AI)
The image shows a pivot table in a spreadsheet application, structured to summarize net amounts categorized by companies with filters for handlers and tasks. (Captioned by AI)1118×147 9.55 KB

I want like below:

The image depicts a spreadsheet likely summarizing financial data categorized by company, handler, task, and time periods with net amounts totaled. (Captioned by AI)
The image depicts a spreadsheet likely summarizing financial data categorized by company, handler, task, and time periods with net amounts totaled. (Captioned by AI)1021×145 8.63 KB

3

Hi @prashant1603765

Can you try to invoke vba activity n use below code
Sub RefreshPivotTable()
Dim pt As PivotTable
For Each pt In ActiveSheet.PivotTables
pt.PivotCache.Refresh
pt.RefreshTable
Next pt
End Sub

Try this hope it works

4

Thanks @vhvinodsai
I created and tested my own VBA code, and it worked successfully. However, the issue I’m referring to is related to the activity involving filtering the Pivot Table. Despite my efforts, the filtering functionality within the Pivot Table is not behaving as expected.

5

Hi @prashant1603765

Put some wait 5000 in between your code n try please mark this as a solution it helps a lot

6

No @vhvinodsai

My issue is that the Pivot Table filter does not display the selected filter value. The activity works correctly, but in the Excel output, the filter field always shows “ALL” instead of the selected value. Please refer to the highlighted field in both Excel files above.