Pivot Table not totaling columns

[Inception952]

Good afternoon all,

I am attempting to summarize insurance data by Line of Business, County, and Zip Code. In order to paste it into my report by row, I have to format the pivot table in Tabular Form. When collapsing the Zip Code field, the numbers I am attempting to total disappear. Is there a way I can obtain the totals by zip code in Tabular Form?

FL DOI Pivot Table.PNG

Thank you!

[romperstomper]

It's hard to tell from a picture, but it looks like you do not have any value fields in the pivot, just row fields.

[Inception952]

Thank you for your reply. Unfortunately I was not able to attach the Excel workbook as it contains confidential data. Moving the Claim Count columns from Rows to Values worked.

Thank you!