+ Reply to Thread
Results 1 to 2 of 2

Date keeps splitting into M/Q/Y in Pivot - how to stop this?

  1. #1
    Registered User
    Join Date
    08-30-2016
    Location
    Edmonton, Canada
    MS-Off Ver
    2016 64b
    Posts
    92

    Date keeps splitting into M/Q/Y in Pivot - how to stop this?

    I have a data model and I want to insert a date; however, the date seems to have loaded intself with four categories (original source just had one):
    - Date (y/m/d)*
    - Date (month)
    - Date (quarter)
    - Date (Year)

    * was the original format loaded into the model.

    Now, whenever I try to load the date* into the model, the other three categories auto-populate and I end up with broken data (i.e. useless information) and the intended category to be filled remains excluded.

    Totally lost on how to resolve this - thank you.

    Resolved; working with very large data. I think Excel was being glitchy and not responding right to my original request. I toggled 'defer layout update' and it worked right.
    Last edited by happydays886; 05-17-2017 at 12:28 PM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Date keeps splitting into M/Q/Y in Pivot - how to stop this?

    "Non-reply" to get you off the unanswered threads list. If you HAVE solved it yourself, can you select thread tools at the top of the thread and mark as SOLVED.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ 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. Replies: 3
    Last Post: 04-01-2016, 01:09 AM
  2. pivot table splitting different colums with same value
    By teddy1987 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-23-2015, 02:21 PM
  3. [SOLVED] Splitting date fails for a part of date column due to different cell format
    By Moriexcel in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 11-21-2014, 01:00 PM
  4. Stop row from splitting on 2 pages when printing pivot table
    By greg28818 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-23-2014, 01:28 AM
  5. Pivot table - stop it summing date entries
    By mra1984 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-05-2013, 06:58 PM
  6. Replies: 12
    Last Post: 08-23-2012, 08:16 AM
  7. Splitting up pivot table fields
    By eoinp in forum Excel General
    Replies: 0
    Last Post: 10-20-2011, 09:16 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