+ Reply to Thread
Results 1 to 8 of 8

Pivot Table Date Output Question

  1. #1
    Registered User
    Join Date
    03-29-2010
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    17

    Pivot Table Date Output Question

    So if I put dates in a pivot table and group them by Year and Quarter, they look like the following:

    A.PNG

    Basically, there's a gap (i.e., blank row) between the quarters when one year jumps to another (i.e., between Q4 and Q1)

    Is there any way to get the pivot table to output them like this.

    2016 Q1
    2016 Q2
    2016 Q3
    2016 Q4
    2017 Q1
    2017 Q2
    2017 Q3
    2017 Q4

    Such that there is no gap between years?

    I'm using Excel 2010. Thanks in advance!

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Pivot Table Date Output Question

    Subtotals OFF
    Report Layout - Tabular form

    if you want blanks: Blanks row - Insert blank line after each item
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Registered User
    Join Date
    03-29-2010
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Pivot Table Date Output Question

    So I right clicked, Field Settings, then did what you said (selected Subtotals None and Show Item Labels in tabular form) but it's still not working. Any thoughts? Thanks in advance.

    B.PNGC.PNG

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

    Re: Pivot Table Date Output Question

    I misread your Excel version - 2013
    I don't remeber PivotTable features in Excel 2003, sorry

  5. #5
    Registered User
    Join Date
    03-29-2010
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Pivot Table Date Output Question

    My fault - forgot to update that. I'm actually on Excel 2010.

  6. #6
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Pivot Table Date Output Question

    so try this

    ptdesign.jpg

  7. #7
    Registered User
    Join Date
    03-29-2010
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Pivot Table Date Output Question

    Worked!!! ty!!!

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

    Re: Pivot Table Date Output Question

    You are welcome

    If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
    then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
    If you did it already - ignore it.
    Thank you.

+ 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. How to do this output from pivot table?
    By ccastell88 in forum Excel General
    Replies: 1
    Last Post: 01-07-2016, 03:58 AM
  2. Output required like pivot table
    By abhijit786 in forum Excel General
    Replies: 3
    Last Post: 09-19-2012, 11:52 AM
  3. pivot table output structure
    By koochandkai in forum Excel General
    Replies: 1
    Last Post: 08-20-2012, 02:37 PM
  4. Pivot table date filtering question?
    By s_zabihi in forum Excel General
    Replies: 10
    Last Post: 12-06-2011, 12:08 PM
  5. Output mask on a pivot table?
    By TK5 in forum Excel General
    Replies: 2
    Last Post: 07-08-2008, 09:36 AM
  6. Table search and position output question
    By yellephant in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-22-2007, 08:35 AM
  7. pivot table output
    By stevekirk in forum Excel General
    Replies: 0
    Last Post: 09-15-2006, 12:47 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