Results 1 to 2 of 2

Excel 2007 : Sum of count filed in Pivot Table

Threaded View

  1. 01-26-2010, 01:22 PM #1
    janaj
    janaj is offline
    Registered User
    Join Date
    01-26-2010
    Location
    Wyoming
    MS-Off Ver
    Excel 2007
    Posts
    1

    Sum of count filed in Pivot Table

    I am fairly new to pivot tables and I have a spreadsheet where the user will enter an X in the data entery spreadsheet. The pivot table counts the total X and I am having trouble summing these counts to a total on the row. The calculated fields of Sum of Total Submitted should be something like (sumD5:N5) and Total Action Taken (sum E5:N5).

    I have tried changing the value field settings and tried several different options for the formula.

    Can anyone help me understand what I am missing?
    Attached Files Attached Files
    Last edited by janaj; 01-26-2010 at 02:01 PM. Reason: Thanks for the quick reply. That seemed to work!
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1