how do i elmininate old data from Report filter on pivot table?

S

Santiago

I need to show on the report fields of pivot table only de data that are on
DB, if a new information change on DB i need to refresh on pivot table, not
only values, besides the data.
 
D

Debra Dalgleish

In Excel 2007, right-click on a cell in the pivot table
Click PivotTable Options
In the dialog box, click the Data tab
From the Number of Items to Retain Per Field dropdown, choose None
Click OK
Refresh the pivot table
 

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
Pivot Table Report Filter - "OR" instead of "AND" Multiple Filters 1
Pivot Table New Data 4
Pivot Table - Changes 5
Pivot Table Data Source 1
date filter in a pivot table 1
Pivot tables - Editing the data source shared by multiple pivot ta 1
pivot table data 2

Top