How can I put an automatic filter in pivot table so that it only shows last 12 months data?
If today is Oct'10, filtered data will show between Oct'09 to Oct'10.
If today is Nov'10, filtered data will show between Nov'09 to Nov'10. This way I won't need to update the filter each month.
How can I do that?
Thanks.
If today is Oct'10, filtered data will show between Oct'09 to Oct'10.
If today is Nov'10, filtered data will show between Nov'09 to Nov'10. This way I won't need to update the filter each month.
How can I do that?
Thanks.