Hi,
I created a pivot table which is refreshed on a monthly basis with the current monthly data.
In the pivot table is there a way to automatically display the recent/rolling 12 months without the use of filter? I am using this data to derive numbers from a line chart I created.
Please help.
Thanks,
Marauder
I created a pivot table which is refreshed on a monthly basis with the current monthly data.
In the pivot table is there a way to automatically display the recent/rolling 12 months without the use of filter? I am using this data to derive numbers from a line chart I created.
Please help.
Thanks,
Marauder