+ Reply to Thread
Results 1 to 4 of 4

Pivot Table Filter Formatting Question

  1. #1
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    445

    Pivot Table Filter Formatting Question

    Hi, i have attached a sample with a simple example.

    in Pivot Tab, my filter is in B1 and i choose 01/08/2017. But at first its at "dd-mm-yyyy" format. I wan it to show as "mm'yy". Hence i format it to "mmm/yy". I thot everything is in order until i choose another date (example, 01-06-2017) it should show Jun'17 coz i already format it to "mmm'yy". HOwever, it show 01-06-2017 again! When i choose 01/08/2017. It show Aug'17. When i choose 01/06/2017 or 01/07/2017, it show "dd-mm-yyyy"

    How to solve this? Also, another one can tell me how to make the Drop down list appear as "mmm'yy" instead of DD-mm-yyyy??
    Attached Files Attached Files

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    Re: Pivot Table Filter Formatting Question

    hi there. you can choose to show All in B1 first before formatting to what you hope to see. it should work after that.

    as for showing the drop down list in mmm'yy, i don't think it's possible.

    i do feel that you should be grouping the dates and using slicers instead. it's much quicker if you have tons of different period and more intuitive.
    1. drag the Date to the ROWS area.
    2. right-click any one of the Date and Group
    3. Choose Month and Year. Click OK
    4. Drag the Month and Year field back to the FILTERS area.
    5. go to the INSERT tab -> Slicer.
    6. select Date and Year. you can now select any month and year you desire.

    Slicers are available from Excel 2010 onwards

  3. #3
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    any
    Posts
    8,750

    Re: Pivot Table Filter Formatting Question

    you want mm'yy or mmm'yy ?
    the way is the same

    (or I misunderstood)

    pt-fieldformat.jpg

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    any
    Posts
    8,750

    Re: Pivot Table Filter Formatting Question

    Welcome

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Pivot Table Filter question
    By melrose0507 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-04-2016, 10:04 AM
  2. Mulitple Pivot Table Filter updates...Excell 2007 question.
    By kriordan13 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-09-2014, 01:12 PM
  3. Replies: 1
    Last Post: 03-08-2014, 02:02 AM
  4. Pivot Table question - formatting
    By c1steady in forum Excel General
    Replies: 6
    Last Post: 02-20-2012, 06:02 AM
  5. Pivot Table filter question
    By angelesta in forum Excel General
    Replies: 1
    Last Post: 08-30-2011, 03:05 PM
  6. Pivot Table formatting question
    By mattbauer in forum Excel General
    Replies: 1
    Last Post: 02-23-2010, 07:59 PM
  7. Pivot Table Formatting Question
    By marmur1 in forum Excel General
    Replies: 3
    Last Post: 04-11-2005, 08:06 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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.06104 seconds
  • Memory Usage 8,978KB
  • Queries Executed 16 (?)
More Information
Template Usage (34):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (4)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (2)postbit_attachment
  • (4)postbit_legacy
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (49):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1