Pivot table and subtotals - limitations?
 

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

Pivot table and subtotals - limitations?
 

When you say subtotals, how are you trying to create them? Pivot tables have
subtotals built in. Trying to use the SUBTOTAL function or using the menu
path Data--Subtotals will not work.

Generally, the pivot table tool will automatically create totals for
something which has subcomponents--i.e., an expense code to which multiple
POs are tied.

Dave
--
Brevity is the soul of wit.


"kimanne" wrote:

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

Pivot table and subtotals - limitations?
 

The pivot tool was not subtotalling automatically (though the 'automatic' box
was ticked off), so i played with the custom subtotal also -- which didn't
work. I believe perhaps my data table isn't set up ideally for subtotals. I
have too many parameters across the horizontal as well as the vertical.
could this be the case? does the data table have to be more '2 dimensional'?

"Dave F" wrote:

When you say subtotals, how are you trying to create them? Pivot tables have
subtotals built in. Trying to use the SUBTOTAL function or using the menu
path Data--Subtotals will not work.

Generally, the pivot table tool will automatically create totals for
something which has subcomponents--i.e., an expense code to which multiple
POs are tied.

Dave
--
Brevity is the soul of wit.


"kimanne" wrote:

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

Pivot table and subtotals - limitations?
 

A subtotal should automatically appear in the pivot table, for a row or
column field that has one or more inner fields.

For example, if you put Date and Service in the Row area, Date should
automatically show a subtotal.

kimanne wrote:
The pivot tool was not subtotalling automatically (though the 'automatic' box
was ticked off), so i played with the custom subtotal also -- which didn't
work. I believe perhaps my data table isn't set up ideally for subtotals. I
have too many parameters across the horizontal as well as the vertical.
could this be the case? does the data table have to be more '2 dimensional'?

"Dave F" wrote:


When you say subtotals, how are you trying to create them? Pivot tables have
subtotals built in. Trying to use the SUBTOTAL function or using the menu
path Data--Subtotals will not work.

Generally, the pivot table tool will automatically create totals for
something which has subcomponents--i.e., an expense code to which multiple
POs are tied.

Dave
--
Brevity is the soul of wit.


"kimanne" wrote:


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



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Pivot table and subtotals - limitations?
 

OK, thank you. I realize the subtotals should show automatically, but when
they didn't - that's where I got stuck. I re-designed the data table to be
more 2-dimensional and now the subtotals appear automatically as should
happen.

Thank you for your time.

"Debra Dalgleish" wrote:

A subtotal should automatically appear in the pivot table, for a row or
column field that has one or more inner fields.

For example, if you put Date and Service in the Row area, Date should
automatically show a subtotal.

kimanne wrote:
The pivot tool was not subtotalling automatically (though the 'automatic' box
was ticked off), so i played with the custom subtotal also -- which didn't
work. I believe perhaps my data table isn't set up ideally for subtotals. I
have too many parameters across the horizontal as well as the vertical.
could this be the case? does the data table have to be more '2 dimensional'?

"Dave F" wrote:


When you say subtotals, how are you trying to create them? Pivot tables have
subtotals built in. Trying to use the SUBTOTAL function or using the menu
path Data--Subtotals will not work.

Generally, the pivot table tool will automatically create totals for
something which has subcomponents--i.e., an expense code to which multiple
POs are tied.

Dave
--
Brevity is the soul of wit.


"kimanne" wrote:


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



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Pivot table and subtotals - limitations?
 

You're welcome. Thanks for letting me know that it helped.

kimanne wrote:
OK, thank you. I realize the subtotals should show automatically, but when
they didn't - that's where I got stuck. I re-designed the data table to be
more 2-dimensional and now the subtotals appear automatically as should
happen.

Thank you for your time.

"Debra Dalgleish" wrote:


A subtotal should automatically appear in the pivot table, for a row or
column field that has one or more inner fields.

For example, if you put Date and Service in the Row area, Date should
automatically show a subtotal.

kimanne wrote:

The pivot tool was not subtotalling automatically (though the 'automatic' box
was ticked off), so i played with the custom subtotal also -- which didn't
work. I believe perhaps my data table isn't set up ideally for subtotals. I
have too many parameters across the horizontal as well as the vertical.
could this be the case? does the data table have to be more '2 dimensional'?

"Dave F" wrote:



When you say subtotals, how are you trying to create them? Pivot tables have
subtotals built in. Trying to use the SUBTOTAL function or using the menu
path Data--Subtotals will not work.

Generally, the pivot table tool will automatically create totals for
something which has subcomponents--i.e., an expense code to which multiple
POs are tied.

Dave
--
Brevity is the soul of wit.


"kimanne" wrote:



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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html