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?
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.
Grahtrue wrote:
> 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?
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks