+ Reply to Thread
Results 1 to 3 of 3

Pivot table filter by specific day of the month

  1. #1
    Registered User
    Join Date
    ny, ny
    MS-Off Ver
    Excel 2010

    Pivot table filter by specific day of the month

    I have a pivot table with first column being dates list for 3 years in increment of 1 day.

    I want to filter this column to show only the dates where the day of the month equals 30.

    Ex: 1/30/2011, 3/30/2011....5/30/2011..etc.

    How do I do that in a pivot table - I use excel 2010.

    Last edited by vesapo; 11-29-2010 at 03:43 PM.

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010

    Re: Pivot table filter by specific day of the month

    As far as I know this cannot be done directly in the Pivot Table, other than using a helper column in the source data.

    If you add a helper column to the source data and use this formula, you can set this helper column as the page field in the Pivot Table and filter on "TRUE" to show only values for a specific day.


    Where cell D1 is an input cell for the "day" ( e.g. 30)
    This approach does require a refresh of the PT when you change the input value.

    Perhaps someone else can provide a better method.

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  3. #3
    Forum Contributor
    Join Date
    MS-Off Ver

    Re: Pivot table filter by specific day of the month

    hey vesapo, yes you need to add a additional column in your source data, just include a new column and add "=IF(DAY(A2)=30,A2,"")", and filter based on the new column

    Hope it helps!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1