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