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

Similar Threads

Pivot table and subtotals - limitations? 5
Doughnut Chart linked with the slicer in the pivot table 0
format pivot subtotals 2
Dealing with a Pivot Table (when I don't want to) 0
multiple subtotals in pivot table 1
Pivot table subtotals 2
Pivot Table Subtotals 1
How do I sort pivot table data by subtotals? 2

Top