How to filter in Excel for A1:B1 based on sytem last month and refresh pivort table

Hi fnds,

How to filter in Excel for A1:B1 based on sytem last month and refresh pivort table…

Thanks in advance!Filter

Hi @venkateshtangudu

Dt.Select("[Month]=‘DateTime.Now.ToString.AddMonths(-1).ToString(“yyyy-mm”)’")

Thanks
Ashwin.S