I'm using XL 2002 and I have a pivot table that has "Grand totals for rows"
turned on. This works perfect. However, amongst the rows of data, I have
one row that is static...it simply shows the 'goal' for the respective
column. I don't want that row to show anything in the Grand Total column.
Is there a trick way to defeat the appearance of the Grand Total for just
that row. Goal doesn't need to have any type of calculation performed on
it...it's simply a reference number for the related dat in the its respective
column that it appears in.

Example:

Item Q1 Q2 Q3 Q4 Grand Total
West 10 20 30 40 100
South 15 25 35 45 120
Goal 5 5 5 5 <---- Have nothing appear here.

Any help would be greatly appreciated.