Results 1 to 6 of 6

Pivot Table creating numerous columns instead of summing data correctly

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-05-2013
    Location
    Oklahoma City, Oklahoma
    MS-Off Ver
    Excel for Mac 2024
    Posts
    142

    Pivot Table creating numerous columns instead of summing data correctly

    In the attached workbook, my Pivot Tables are working fine for summing up the data in columns by Month but it is not summing it up correctly by Year. There is only three years of data - 2012, 2013, and 2014. Instead of aggregating the data by year into three columns, it creates a new column for every entry - i.e. creating over 900 columns! Why is that and how do I fix it? See file named Excel Forum Help. Thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot table not displaying data correctly
    By Klipvis in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-23-2014, 06:24 AM
  2. [SOLVED] Pivot Table? over multiple columns : or other summing method?
    By skyping in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-27-2014, 07:21 AM
  3. Problem Summing columns from pivot table
    By VJEF in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-22-2013, 04:45 PM
  4. Replies: 2
    Last Post: 03-07-2013, 02:16 PM
  5. [SOLVED] How to move numerous sets of data from columns to rows within a table?
    By Rob8489 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2012, 05:58 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