I am having an issue in correcting a pivot which refreshes on running a macro.
In the attached workbook, the macro named "ref_pivot" is used to refresh the pivot with the tables values and also apply filters to the pivot item.
What I am trying to achieve is to apply filter to the pivotitem "Org_Sched_Month" to filter for the months from today and before. However it is not selecting the current month and selecting the month of May instead.
Any help is much appreciated. Macro enabled workbook attached.
Bookmarks