Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals not working for Pivot Table
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals not working for Pivot Table
See my response to your previous post.
-- Brevity is the soul of wit. "kimanne" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table subtotals | Excel Discussion (Misc queries) | |||
Pivot Table Subtotals | Excel Discussion (Misc queries) | |||
Crate group of date, with Dynamic Range in pivot table not working | Excel Discussion (Misc queries) | |||
Pivot Table unable to Include Hidden Items In Subtotals | Charts and Charting in Excel | |||
Pivot table. Calcualting % from subtotals. | Excel Worksheet Functions |