Custom date fields for pivot tables

A

Amijab

I have a pivot table that is updated daily, but for reporting purposes, I
only want to include the last 14 days in my report . I see date filters for
this week or last week, this month or last month, but how do I create a
custom filter for =today()-15?

Thank you!!
 
B

Bernie Deitrick

You could add a column of formulas to your data table, with a formula like

=A2 > (TODAY()-15)

and then use TRUE as your filter...

HTH,
Bernie
MS Excel MVP
 
A

Amijab

Bernie, thanks for the quick response.

I will go ahead and do that for the one report that I have, but my
preference is to create the moving data range in the pivot table (PT). The
reason for this is I have multiple pivot table reports with rolling date
ranges (i.e. the past 14 days, the past 30 days, the past 90 days, etc.)
these PT's in turn populate graphs. I am currently manually selecting the
dates each day. It seems to me that there would be the ability to create a
date range using the "custom date" filter. Is this possible?

Thanks again for your help!!!
 
B

Bernie Deitrick

When you recalc your workbook and refresh your pivot table, those values will update, so it will be
a 'moving data range', or at least as automatic as you can make it. Just make sure that you extend
your formulas to match your data- which can be an automatic option, based on your version.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rolling 12 month date filter for pivot table? 2
Dynamic 5-week date range & SUMPRODUCT formulas 0
Pivot Table Summary Error? 6
Use Sum() with variable range 4
Pivot Table Comparison 1
Pivot Table sorts date as Alpha, not as Date 6
Weekending Date w/Less Than 3 days Assoc. with Prior Month 7
Problem with pivot tables 1

Top