I'm not sure how to ask this, but here goes. A pivot table show only
that data at each break in the sort. For example if I had a car
database with manufacturer, model, and count, the pivot table might
show this

Chevy Malibu 10
Corvette 20
Ford F150 5
Tempo 15
Dodge charger 3