Pivot table data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table of data which I want to analyse with a pivot table. The table
has a date column.

Is there a way of specifying data shown in the pivot table to only include
dates greater than a date I select?
 
You could add a column to the pivot source table, and calculate if the
dStartDate meets the criteria. For example if date is in cell A2:
=A2>=TODAY()

Add this new field to the PivotTable page area, and filter for TRUE.
 
You must log in or register to reply here.

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

Pivot table filter list - listing irrelevant subcategorys 1
date filter in a pivot table 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot table 1
Pivot Table date format 1
Adding to an existing Pivot Table 7
Pivot table date grouping 2
Pivot ungrouping on refresh? 3

Back
Top