To show hidden subtotals for a pivot table field in Excel 2003, right click in the field or double click the field title in question. Then choose "Field Options" (if right clicking). Choose the option "Automatic" under the "Subtotals" heading and click "OK".