Dynamic date range

C

Crazy AL

I have a pivot table based on customer name (vertially, rows) and product
(across, columns). In each record is the date.
How can I base my pivot tables selection on a dynamic date range.
Specifically to display records only as far back as 6 months. Lets say
"today less 182 days", if that makes it easier.

Thanks,

AL
 
B

Bernie Deitrick

AL,

What I prefer doing is putting a column of TRUE/FALSE formulas into the
source range, like

=A2>(DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())))

Then use that column as a page or row field, choosing TRUE.

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

How I can set dynamic pivot table ONLY when I have enough data point 1
Crate group of date, with Dynamic Range in pivot table not working 3
crate group of date, with Dynamic Range in Pivot Table but not wor 3
Pivot Table - Efficient Source Range 2
Filtering a dynamic range 5
filtering dates in a Pivot Table Report Filter 3
Dynamic Data Range from External Text File, Filter 2
hLookup dynamic range 2

Top