Pivot Table filters

KDecker

New Member
Joined
Nov 9, 2017
Messages
5
Hi -

I inherited a spreadsheet that I'm trying to understand/edit. In it, there is a large table of data and a pivot table for summary. The pivot table is filtered on a column called "post date".

In the "post date" column in the data table, there appear only dates in April (4/01, 4/02, 4/03, etc) however, in the pivot table filter selection, there are many other dates (5/01, 2/05, 4/02, etc... I'm not sure where these dates are coming from. I assume they are either pulling from a list (like data validation would do) or they were set up with some sort of custom method.

Ultimately, I want the filter to only show dates included in the "post date" column in the data table. How do I do this?

Thanks in advance for any help.
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

SpillerBD

Well-known Member
Joined
Jul 2, 2014
Messages
2,707
A Pivot Table Filter may list values from a previous Data Set. This is controlled through the PIVOT TABLE OPTIONS... Data Tab, "Number of items to retain per field"
 

Watch MrExcel Video

Forum statistics

Threads
1,122,822
Messages
5,598,304
Members
414,224
Latest member
Crazy_FC

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top