| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pivot table data
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? |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) | |||
| I am having problems creating pivot table of data | Charts and Charting in Excel | |||
| pivot table in data source order | Excel Discussion (Misc queries) | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions | |||
Linear Mode
