How to filter pivot table

Hello People,

I have Scenario where Template.xlsx Workbook Contains FG Variance Sheet and Corresponding pivot sheet (Sheet 1) in the Template.xlsx.

FG Variance Sheet Data comes from SAP Application That i will paste in Template.xlsx after pasting data i need to refresh pivot sheet (table) ,

though i am able write the data from SAP Application data to workbook and refresh pivot i am getting (blank) values added to my pivot table so how do i filter (blank)values ??

Need Suggestions…

Thank You

Hi @ShivuDundi,

You could try to use the Filter Data Table activity on the data table behind your “SAP Application data”

Perhaps it should look like this:


Hope this helps
Best regards,