Subtotals not working for Pivot Table

K

kimanne

I have built a table of data which compares various competitor prices for
multiple services by time of day (morning, afternoon, evening). I have
created a pivot table and would like to subtotal the total of all services
for the period of the day. So for example I would compare the subtotal price
of a manicure plus the price of a pedicure for each competitor during the
morning, during the afternoon and during the evening. However whether i
check that subtotals are 'automatic' or customize to 'sum', no subtotals
appear on the pivot table - neither by competitor name nor by daily session.
does anyone have any suggestions on what I may be doing incorrectly? thank
you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top