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.
Bookmarks