When you say subtotals, how are you trying to create them? Pivot tables have
subtotals built in. Trying to use the SUBTOTAL function or using the menu
path Data--Subtotals will not work.

Generally, the pivot table tool will automatically create totals for
something which has subcomponents--i.e., an expense code to which multiple
POs are tied.

Dave
--
Brevity is the soul of wit.


"kimanne" wrote:

I am using Excel 2002. I built a data table and have created a pivot table,
but i cannot get the subtotals to appear. My data is a table of competitor
prices for particular services during certain sessions of days in the week.
For example the prices for manicures and prices for pedicures during the
morning, afternoon and evening sessions for all the days of the week. i
would like the pivot table to show the subtotal of mani plus pedi (as well as
individually) for these sessions on any given day. can anyone advise me on
what i may be doing incorrectly? are there too many parameters thus causing
the subtotals not to work? thank you