+ Reply to Thread
Results 1 to 3 of 3

Everytime I choose a date due for my pivot table it auto selects Quarters and years

  1. #1
    Registered User
    Join Date
    01-25-2018
    Location
    usa
    MS-Off Ver
    excel 2016
    Posts
    1

    Exclamation Everytime I choose a date due for my pivot table it auto selects Quarters and years

    I am having trouble with my pivot table. Every time I select date due it auto selects years and quarterly. How do I turn the feature off?

  2. #2
    Registered User
    Join Date
    08-08-2017
    Location
    Florida
    MS-Off Ver
    O365
    Posts
    40

    Re: Everytime I choose a date due for my pivot table it auto selects Quarters and years

    I am new to pivot tables so I don't know if this is right but hopefully it will help.

    You can right click on the year or quarter in your pivot table and click ungroup. You can also click group and choose how you want the dates to be grouped. If you want to group by weeks I think you have to select days and then change the number to 7

  3. #3
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Everytime I choose a date due for my pivot table it auto selects Quarters and years

    Can you attach a sample of your pivot table.

+ 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. Auto refresh Auto filter excluding Zeros after chagnig date everytime
    By anwitha in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-08-2015, 08:09 AM
  2. Auto Populate quarters by just typing in the number of years
    By sugar_lips in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-27-2014, 09:31 AM
  3. Pivot Table Date Adding 4 Years and 1 day to Source Data Date
    By dhanni in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-05-2014, 02:20 PM
  4. [SOLVED] Pivot table sort by calendar date quarters
    By Xx7 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-26-2014, 10:02 PM
  5. Pivot Table Year to Date for Current and Previous Years
    By BFid in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-07-2013, 05:28 PM
  6. Replies: 0
    Last Post: 11-28-2007, 06:57 AM
  7. Pivot Table Grouping by Quarters
    By Gary Brown in forum Excel General
    Replies: 3
    Last Post: 03-29-2006, 12:49 AM

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