+ Reply to Thread
Results 1 to 3 of 3

Two pivot fields in column - not displaying one of them

  1. #1
    Forum Contributor heytherejem's Avatar
    Join Date
    07-06-2017
    Location
    Hampshire, England
    MS-Off Ver
    2016
    Posts
    152

    Two pivot fields in column - not displaying one of them

    Hello,

    I'm sure i'm doing something very obviously wrong but a standard pivot seems to have eluded me.
    Attached is my pivot, I want to view the 'month' and the 'cost type' as columns so it displays like this:

    Month
    Cost type 1 Cost Type 2 Cost Type 3

    ... and so forth. But cost type is not appearing in the pivot. When I move it above Months so it looks like the below it works:

    Cost Type 1
    Month 1 Month 2 Month 3

    What am I doing wrong???
    Attached Files Attached Files
    Last edited by heytherejem; 06-27-2018 at 12:07 PM.

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,909

    Re: Two pivot fields in column - not displaying one of them

    I'm not quite sure what happened, but ungrouping the date field and then regrouping it fixed the display for me. You can then also centre the months across selection without merging.

  3. #3
    Forum Contributor heytherejem's Avatar
    Join Date
    07-06-2017
    Location
    Hampshire, England
    MS-Off Ver
    2016
    Posts
    152

    Re: Two pivot fields in column - not displaying one of them

    Ha, yep that worked for me too! 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. Pivot table displaying incorrect Column data
    By Mile029 in forum Excel General
    Replies: 11
    Last Post: 09-11-2018, 02:03 PM
  2. [SOLVED] Displaying Totals of one column value in Pivot
    By callummcgrath in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-04-2017, 08:30 AM
  3. [SOLVED] Help on VBA to select all column dates into pivot fields
    By johnmacpro in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-29-2016, 01:06 AM
  4. Pivot Chart not displaying any data/fields
    By collmehank in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-29-2015, 02:32 PM
  5. Convert Column Data Fields to Row Data Fields in pivot table
    By anavarathan in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-08-2014, 09:49 AM
  6. Replies: 3
    Last Post: 09-27-2010, 08:59 AM
  7. Differentiate between column fields and data fields in a pivot table
    By whiteheadw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2009, 01:59 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