Results 1 to 2 of 2

DAte filter on Pivot Table

Threaded View

  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

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