I'm very new to pivot tables. I've got an Excel file that I put a pivot table in which creates a report form for trash found during site surveys. Users can select the site and date of the survey, and the report shows the category, details, comments and the total number of items found for each detail.
I'm trying to find a way to create a sum for each category. Ideally, it would be in a row at the end of the category. I don't think it's a field I can create in the source table, because it depends on the variables selected. I've tried using the Subtotal feature, but that's not giving me the desired SUM result, just adding lots of extra rows. I can;t seem to figure out how calculated fields work in this table.
I'm attaching a screenshot. Ideally, I'd like the row inserted at the red line, summing up the highlighted numbers above.
pivottable1.JPG
Bookmarks