Pivot Table total

[TonyforVBA]

In my pivot table I'm getting a total row on every option (see attached workbook)
How can I get rid of these. I only want a Grand total at the bottom on the table.

Thanks

[tom1977]

In attachment changed pivot
I use ex 2007 and do not know where find this function in ex 2003 sorry

[TonyforVBA]

Thanks for that Tom, thats exactly what I'm lookign to do. Where is the option to remove these sub totals in 2007?

Does anyone know if this is even possible in 2003?

[tom1977]

ex 2007 if You select pivot on a ribbon will appear new tab with "tools of pivot table" one of them is probably call "design" and where You click this on the left should be icon "subtotal".
The names could be different that I wrote because I do not use English version of ex.

Does anyone know if this is even possible in 2003?

For sure it is!

[TonyforVBA]

Select Field_Settings from the Dropdown menu. Sub total options are found there in 2003.