Formatting Totals in a Pivot Table

[brent_milne]

I have a pivot table with with a list of companies and it does show the subtotals but it also shows a '1' for each company in the total (Count of Companies that was placed in the Values). I was wondering if there is a way to only show the subtotal and not display the '1'. I was playing around with a few things but couldn't figure it out but thought that conditional formatting might be a way to do it. I just am not sure of the formula to use so any help would be greatly appreciated. I've attached a sample of what my pivot table looks like and you will be able to see the '1' that I don't want to see in the 'Total' column.

[queuesef]

Subtotal on what??? You can change the COUNT to SUM. In Pivot Table -Values Click on the Total and change to Sum.