Is it possible to create a pivot table to only show the last twelve months data? I have attached an example of the data but I only want to show the last 12 months of data in the pivot table automatically.
Is it possible to create a pivot table to only show the last twelve months data? I have attached an example of the data but I only want to show the last 12 months of data in the pivot table automatically.
Why not include this formula in Column C
=IF(A2>(TODAY()-365),"Include","Exclude")
And base the Pivot on that, add in the Column to the Filters section in the Pivot Setup?
This formula would work for 1 year (365 days). What would work for the months? Today is July 15th. I do not want to lose July 1-14, 2014 data.
How about
=IF(A2>(DATE(YEAR(TODAY()),MONTH(TODAY()),1)-365),"Include","Exclude")
Modification;
=IF(A2>=(DATE(YEAR(TODAY()),MONTH(TODAY()),1)-365),"Include","Exclude")
Awesome! That works great. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks