Clips has an 11-unit record, larger than either individual Tape record. The question is which two categories have the most units after you add each category’s records.

Build the category totals

Use source rows Tape 9, Labels 12, Tape 8, Clips 11, and Labels 2. In Ulet, select the source and choose Data → PivotTable. Use Category in Rows and Sum of Units in Values.

Tape’s 9 and 8 sum to 17, while Labels’ 12 and 2 sum to 14.

Illustrated aggregation. Rank totals rather than single records.

Set Top N to 2 on the summed value

Create the pivot and expect Tape 17 and Labels 14. Verify that Clips 11 remains in the original log. If you need the total across all categories, reconcile it with the unfiltered log before quoting it. When two categories tie at the cutoff, inspect how the chosen filter handles the tie.

The Top N output keeps Tape and Labels and leaves Clips in the log.

Illustrated filtered result. Check the unfiltered total separately if needed.

Microsoft’s reference for PivotTable value filters