Results 1 to 11 of 11

Summing pivot fields where value is 1

Threaded View

  1. #1
    Registered User
    Join Date
    05-13-2013
    Location
    Portland, Oregon
    MS-Off Ver
    Excel 2010
    Posts
    6

    Question Summing pivot fields where value is 1

    I have a report series for monthly injuries reported at all my company's locations. I filter by location and display the injury types and the number of each, as per the sample workbook attached. From this, a pie chart is built for each location.

    The problem is that there are always so many one-shot injury types (we encourage reporting of every single incident, no matter how minor) that an automatic pie chart invariably includes so many tiny slivers that the chart is impossible to read. I've been manually summing the single incidents, copying it and the rest of the injury data to another location in the worksheet, and building the pie chart from that.

    When these reports were done on an ad-hoc, by-request basis, I could afford the time to monkey with the single incidents, but now I have to make the reports monthly, and there are nearly 70 locations involved. Is there a way to make injury types of "1" sum up into a "Miscellaneous" field automatically within the pivot table? (I'm using Excel 2010.)
    Attached Files Attached Files

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