Closed Thread
Results 1 to 2 of 2

DAte filter on Pivot Table

  1. #1
    Registered User
    Join Date
    07-22-2015
    Location
    Sydney
    MS-Off Ver
    2013
    Posts
    30

    DAte filter on Pivot Table

    Hi ,

    can you assist with the format in the filter on the pivot table to be able to search by year and month. the dates are listed as individual dates as per attached screen shot. i would like to have in the "correct format" pic.

    Regards
    Rajeev
    Attached Images Attached Images

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: DAte filter on Pivot Table

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Set Pivot table Filter to a date range using VBA
    By BlueDan2015 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-05-2015, 07:58 AM
  2. Pivot Table: OR condition filter on Multi Date/Sum Filter
    By ddalt10 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-09-2013, 12:49 PM
  3. VBA to control Pivot Table Date Filter
    By HeebieGeebie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2013, 08:06 AM
  4. [SOLVED] How to set a 'Date Filter' on a field in the 'Report Filter' section of a Pivot Table?
    By Rhino_dance in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-28-2013, 11:01 AM
  5. Pivot Table - Date Report Filter
    By nathanB in forum Excel General
    Replies: 2
    Last Post: 11-28-2012, 08:40 AM
  6. Date filter on Pivot Table?
    By umss in forum Excel General
    Replies: 1
    Last Post: 03-27-2012, 03:33 AM
  7. Pivot Table Date Filter
    By coolzero in forum Excel General
    Replies: 1
    Last Post: 07-09-2010, 04:11 PM

Bookmarks

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