u/Calebcito143

▲ 2 r/excel

Hey guys,

I’m not the most proficient in Excel, and I was working on this pivot table. I want to have the total count of items at the end, but I don’t want each individual count to appear as part of the table (the columns highlighted in yellow).

I’ve been searching for a solution, but the only option I’ve found so far is hiding those columns. Do you guys know of a way to add the total count without showing the individual counts?

Any help would be greatly appreciated. Thanks!

https://preview.redd.it/8hi83p28ruzg1.png?width=1883&format=png&auto=webp&s=b17d476a3b6ecc601a6dd3821adba235ef4f97bc

reddit.com
u/Calebcito143 — 6 days ago