+ Reply to Thread
Results 1 to 4 of 4

Pivot table not displaying figures correctly

  1. #1
    Registered User
    Join Date
    01-03-2014
    Location
    Miami, FL
    MS-Off Ver
    Excel 2010
    Posts
    5

    Pivot table not displaying figures correctly

    Hello,

    I'm attaching a worksheet I'm having trouble with. Each entry has a total number of LINES (input by hand), a total amount of TIME (calculated by formula), a total number of CAPTIONS (input by hand), and a total amount of TIME2 (calculated by formula). I created a pivot table so I could see these four values by date, and also so I could see totals when I filter by other criteria such show names. But in the pivot table all the values come up as one-digit numbers. In the worksheet the LINES and CAPTIONS are usually 3-digit numbers, and the TIME and TIME2 are set up to display in H:MM format, but in the pivot table they don't appear that way at all.

    I figure there's a formatting problem I can't seem to understand. If anyone can help me solve the aforementioned situation, I would be so grateful!

    The other option is to just use the filters in the table on the worksheet, but when I filter anything out the grand totals at the end of the table do not adjust, they continue to show the overall grand totals. Perhaps if I could get these totals to adjust whenever I use the filters, then I wouldn't need a pivot table.

    I hope this makes sense. Attached are the files. Thank you for any help or information you can provide!

    Angie
    Last edited by angie450; 01-07-2014 at 02:33 PM. Reason: Solved

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Pivot table not displaying figures correctly

    Your fields are set to Count - you must change them to Sum, and format the time cells as [h]:mm if there may be greater than 24 hours in one value total.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  3. #3
    Registered User
    Join Date
    01-03-2014
    Location
    Miami, FL
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Pivot table not displaying figures correctly

    Wow, so simple and I might never have figured it out. I just made the changes and it works great! Thank you!!!

  4. #4
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: [SOLVED] Pivot table not displaying figures correctly

    You are welcome.

+ 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 set up a Pivot Table correctly
    By Cavrunin in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-08-2013, 01:04 PM
  2. pivot table from Power Pivot not displaying thousand separator/comma
    By Paul-NYS in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-04-2013, 01:05 PM
  3. Pivot table figures come up in $
    By Markiemark in forum Excel General
    Replies: 0
    Last Post: 10-31-2011, 12:35 PM
  4. Replies: 3
    Last Post: 09-20-2011, 05:02 AM
  5. [SOLVED] Hide 0% figures in Pivot Table
    By Matt D Francis in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-04-2005, 05:50 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