Removing the Row Total from a Pivot Table

[Gazzr]

Hi All,

I am creating a Pivot table based on the following Columns of Data, Customer Name, AgencyName, Year, Spend.

When I create the PT I am using Year as the column set, and CustomerName and AgencyName (in that order) as the rowset. The data in the middle is the SUM of SPEND.

In cases where there is more than one agency associated with a customer I get:

Customer Name, Agency Name, Spend
Garry Customer Travel
Travel Agency 1 $1000
Travel Agency 2 $2000
Travel Agency 3 $3000
Garry Travel Total $6000

OK what I want to do is get rid of the row "Garry Travel Total". Is there a way to do this with the Pivot Table or would I be better writing a macro to delete all line with Total in the last 5 chars of each row?

Thanks
Garry

[psumvp]

Make sure the Garry cell is the active one (within the pivot table, not on the subtotal), right click and choose field settings. Then on the left, change the setting from automatic to none.

[Gazzr]

Thats great!, I couldnt find the automatic to none setting but just right clicked in the subtotal row and selected "Hide"
Thanks
Garry