+ Reply to Thread
Results 1 to 3 of 3

Making a pivot table with fixed columns possible?

  1. #1
    Registered User
    Join Date
    02-13-2017
    Location
    pittsburgh
    MS-Off Ver
    2007
    Posts
    16

    Making a pivot table with fixed columns possible?

    Hi All. I currently have a data tab with monthly data that is dropped in at the end of each month. My columns in the pivot table are months that are part of the data set. my rows are categories that are part of the data set. Is there anyway I can have FIXED rows and FIXED COLUMNS. For example; right now there is no data for the month June so there is no June column... Is there anyway to have Jan - Dec columns fixed all the time even if there is no data from the pivot table.

    To simplify I just want a 12 month table even if there is no data for some months... I know I can use sumifs but I need to use a pivot table because I need slicers.

    Thanks!

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,593

    Re: Making a pivot table with fixed columns possible?

    Hi,

    You could include a set of blank records, one for each month.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Valued Forum Contributor
    Join Date
    03-16-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    371

    Re: Making a pivot table with fixed columns possible?

    If you've got your columns setup as a date hierarchy (pivot table grouping) you can change the field settings to include items with no data.

+ 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. Help with making two pivot table columns
    By bossman71 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-05-2015, 07:15 PM
  2. [SOLVED] Making a chart from a single table no pivot table
    By sportfan in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-30-2015, 02:15 AM
  3. Making a pivot table work with rest of a table
    By Excelfail in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-31-2015, 10:47 PM
  4. [SOLVED] Filter Pivot Table with a fixed value called "TOTAL" in Pivot Field Name
    By trizzo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2015, 12:57 PM
  5. Fixed Filter on Pivot Table
    By martinpaiva in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-28-2013, 03:45 PM
  6. [SOLVED] VBA Pivot Table with Fixed Rows
    By excelnewbie80 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-09-2013, 10:02 AM
  7. VBA Pivot Table fixed Row Fields
    By jrs22 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-30-2010, 09:26 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