Apply filter to pivot table fields.

[ashish.kumar21031995]

I have a excel sheet and in that i have to filter pivot table field. there i have to untick the previous month and select present month . when I record the macro I get following code . Please help me to convert this code suitable for blue prism Code stage . I am facing lots of issues in doing this .

ActiveSheet.PivotTables("PivotTable1").PivotFields("[Time].[Month].[Month]"). _
VisibleItemsList = Array("[Time].[Month].&[2018]&[4]", _
"[Time].[Month].&[2018]&[7]")

 

[VJR]

I have a excel sheet and in that i have to filter pivot table field. there i have to untick the previous month and select present month . when I record the macro I get following code . Please help me to convert this code suitable for blue prism Code stage . I am facing lots of issues in doing this .

ActiveSheet.PivotTables("PivotTable1").PivotFields("[Time].[Month].[Month]"). _
VisibleItemsList = Array("[Time].[Month].&[2018]&[4]", _
"[Time].[Month].&[2018]&[7]")

Hi ashish.kumar21031995,

You did not post back with your inputs on the thread you opened for the same topic.
http://rpaforum.net/threads/apply-filter-to-pivot-table-rows.1953/#post-6627
I have provided you the code on the other post but did not hear back from you on what is the code you are using.
Also the code in the above link can be made use of in conjunction with the code in this link. Try them out as suggested in both the links above and post back with your observations.