Adding addtional Subtotal to Pivot Table

Hello - I have a Pivot table in Excel 2010 that I created which looks something like:

Values
Country Building ID State City Contract# $Value
Building ID State City Contract# $Value
Country Total 2 5,000.00
Country Building ID State City Contract# $Value
Building ID State City Contract# $Value
Country Total 2 12,000.00


I added subtotals for Country that gives me subtotals for the Value columns (Count for Contract# and Sum of $Value). But I would like to add also a subtotal for Building ID and City that would give me a Count of each. Would someone be able to tell me how I would do that. I tried going into field settings for those fields and doing a Custom Subtotal using Count. That adds a Count to the column, but it also removes the subtotals on the Country column.

Any suggesstions greatly appreciated! Thank you in advance.

Hi,

I cant see a pivot table in your uploaded workbook. Is it the data source? If so i would recommend you to not include any subtotals in your data source.

/Masun