Hello All,
Love this discussion group, someone always seems to have the answer I need.
I've got a pivot table with subtotals and I'd like to average the
individual entries using the subtotals, not grand total.
Is this something that can be done?
Thank you.

Jim

Double-click on the field button for the row field that you want to average.
Under Subtotals, click Custom
Click on the Average function, then click OK

Blueglass wrote:
Love this discussion group, someone always seems to have the answer I need.
I've got a pivot table with subtotals and I'd like to average the
individual entries using the subtotals, not grand total.
Is this something that can be done?

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

Thanks for the information. I don't think I stated my question correctly.

I'd like to calculate the average of each data item using the subtotal for
the denominator.
Here's the way the pivot looks. I'd like to get the average for each
Resource based on the subtotal. (Engr=17%, Admn=17%, etc.)

WBS Desc Res Hrs
1.1.1 Program Mgmt Engr 10
Admn 10
S/W 10
H/W 10
Tech1 10
Tech2 10
Subtotal 60

"Debra Dalgleish" wrote:

Double-click on the field button for the row field that you want to average.
Under Subtotals, click Custom
Click on the Average function, then click OK

Blueglass wrote:
Love this discussion group, someone always seems to have the answer I need.
I've got a pivot table with subtotals and I'd like to average the
individual entries using the subtotals, not grand total.
Is this something that can be done?

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

You can't use the subtotals in calculations within the pivot table.
Perhaps you could arrange the pivot table differently, and use a % of
Row custom calculation, as described he

http://www.contextures.com/xlPivot10.html

Blueglass wrote:
Thanks for the information. I don't think I stated my question correctly.

I'd like to calculate the average of each data item using the subtotal for
the denominator.
Here's the way the pivot looks. I'd like to get the average for each
Resource based on the subtotal. (Engr=17%, Admn=17%, etc.)

WBS Desc Res Hrs
1.1.1 Program Mgmt Engr 10
Admn 10
S/W 10
H/W 10
Tech1 10
Tech2 10
Subtotal 60

"Debra Dalgleish" wrote:


Double-click on the field button for the row field that you want to average.
Under Subtotals, click Custom
Click on the Average function, then click OK

Blueglass wrote:

Love this discussion group, someone always seems to have the answer I need.
I've got a pivot table with subtotals and I'd like to average the
individual entries using the subtotals, not grand total.
Is this something that can be done?

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





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