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