+ Reply to Thread
Results 1 to 11 of 11

Summing pivot fields where value is 1

Hybrid View

Leanne_B Summing pivot fields where... 05-13-2013, 02:13 PM
judgeh59 Re: Summing pivot fields... 05-13-2013, 02:47 PM
Leanne_B Re: Summing pivot fields... 05-13-2013, 03:02 PM
judgeh59 Re: Summing pivot fields... 05-13-2013, 03:04 PM
Leanne_B Re: Summing pivot fields... 05-13-2013, 03:07 PM
judgeh59 Re: Summing pivot fields... 05-13-2013, 03:11 PM
Leanne_B Re: Summing pivot fields... 05-13-2013, 03:16 PM
judgeh59 Re: Summing pivot fields... 05-13-2013, 03:22 PM
Leanne_B Re: Summing pivot fields... 05-14-2013, 01:41 PM
judgeh59 Re: Summing pivot fields... 05-14-2013, 01:48 PM
Leanne_B Re: Summing pivot fields... 05-14-2013, 02:00 PM
  1. #1
    Registered User
    Join Date
    05-13-2013
    Location
    Portland, Oregon
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Summing pivot fields where value is 1

    My original upload was simply a pivot table that filtered injury data by location and dumped the injury types and their totals. My original question was about how to force the summing of all the one-shot injuries into a single "miscellaneous category," which we've accomplished.

    However, the ultimate goal is to create an automatically-generated display of this data that will yield a usable pie chart. As it stands, I haven't figured out a way to get that clean display. For example, in the latest version of the workbook, the pivot table is displaying one injury type at 10, another at 4, four others at 2, and five at a value of 1. My goal is to find a way to make a table that shows the injury types at 10, 4, and 2 broken out by name, and all the single injury types lumped together as "miscellaneous" with a cumulative total.

    Thanks for your continued help.
    Attached Files Attached Files

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1