How to apply filter in pivot table with Blue Prism

Julio_SC

New Member
Hello I'm trying to apply filters on a dynamic table with Blue Prism, I have to run filter in the column Date selected only the date of the previous day and today's day but I have no idea how to create the code. I hope you can help me
 

Attachments

  • what I have.PNG
    66.7 KB · Views: 61
  • what I need_1.png
    8.6 KB · Views: 50
  • what I need_2.png
    36 KB · Views: 48

RsBhargav

Member
Hi Julio,

The data looks like a normal table, so can you read the data to a collection and then use filter on that particular column using "filter collection" action in collection manipulation VBO.

later we can replace it on the same excel sheet.


Thanks,
Rs
 

ADITYA_RPA

New Member
ActiveSheet.PivotTables("PivotTable45").PivotFields("EOW status change")
.PivotItems("28-Dec-2019").Visible = True
i want to Apply filter on pivot pivot table name is PivotTable45 and PivotFields is EOW status change the item to add is PivotItems 28-Dec-2019
should any one help how that will do with dynamicaly using action
 
Top