For any column you don't want subtotaled, right-click the field header and
then select "Field Settings" from the drop-down. Then, on the "Subtotals &
Filters" tab, change the 'Subtotals' from "Automatic" to "None." Do this for
any and all fields you don't want to be subtotaled, and you should achieve
your goal.

Jeff


"Robbro" wrote:

I'm new to pivot tables and really like them, using one could help me greatly
simlplify some reporting I do, however I cannot figure out how to show
subtotals only on certain columns, it appears to be all or nothing. Showing
them results in some non-sense garbage on my reports that I cannot have. I
think this is my last hurdle to actually using pivot tables and hope there is
a way to remedy this.