PivotTable - Show Range of Dates

Which area of the PivotTable are your PivotFields with Date Submitted and Date Completed placed?
Are they in the Report Filter (PageField), RowField or ColumnField?

Thanks for the reply,

Right now, I just have them under Row Labels, but I could live with Column Labels, too.

I can summarize the values to show the Min and Max of these dates which will show me the oldest and most recent dates, but I'm trying to get the last 30 days.

Thanks again

Well, I ended up just fudging it and now have what I needed.

I just made a separate pivottable of my formulas, so I ended up with essentially the exact same data in multiple cells, but those are 'source' sheets for my dashboard, so that's alright.

Good to hear you got it to work.

For Dates in the Row Labels area, these are two alternatives to consider.

1. You can Filter the PivotField for a date range.
Right-Click on a Date label> Filter > Date Filters > Show items for which the date: > is after > (enter a date).
There are a lot of date filter options like "This Month", "This Year", but unfortunately there isn't one that you can set to "Last 30 Days".
You could make a fairly simple macro using the macro recorder to do the manual steps above then substitute a specific date with a variable that will evaluate to today-30 days.

2. Add a column named "Last 30 Days" to your data source with a formula for each row that will evaluate to "Yes" if that row's Submitted or Completed Date was within the last 30 days. Then add this "Last 30 Days" field as a Page Filter and set the filter show only "Yes" data. You'll just need to refresh the pivottable to have the Yes/No values updated in the Pivot Cache based on today's date.

JS411 said:

2. Add a column named "Last 30 Days" to your data source with a formula for each row that will evaluate to "Yes" if that row's Submitted or Completed Date was within the last 30 days. Then add this "Last 30 Days" field as a Page Filter and set the filter show only "Yes" data. You'll just need to refresh the pivottable to have the Yes/No values updated in the Pivot Cache based on today's date.

Click to expand...

I thought about this option, but I'm not sure how to use it. I even went as far as creating two more columns for Days Since Submitted and Days Since Completed, thinking I could filter on Less Than or Equal To but I haven't played with it enough yet.

Thanks for your help!