I lost my sub-totals in my pivot table.
I was trying to do a summary by dept of wages, shift prem and other. Then
for each dept I would get a sub-total.

I double-clicked on "Dept" and it showed that the sub-totals were set at
automatic but it still does not display.

Thank you in advance for your help. It would be greatly appreciated

Do you have more than one field in the Row area?

LaNaveau wrote:
I lost my sub-totals in my pivot table.
I was trying to do a summary by dept of wages, shift prem and other. Then
for each dept I would get a sub-total.

I double-clicked on "Dept" and it showed that the sub-totals were set at
automatic but it still does not display.

Thank you in advance for your help. It would be greatly appreciated


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

Dept is the only row.
No columns.
Data area:
Sum of "Salary"
Sum of "Shift Prem"

So there will be an amount for Salary and an amount for shift prem by each
Dept. I am missing the total of the Salary and Shift prem by Dept which is
the 3rd line for each dept.

Example:
Dept
700 Sum of Salary 1000.00
Sum of Shift Prem 500.00

What is missing is Total for Dept 700 1500.00 on the next line.

If it helps, I could send the pivot table.

Thanks.



"LaNaveau" wrote:

I lost my sub-totals in my pivot table.
I was trying to do a summary by dept of wages, shift prem and other. Then
for each dept I would get a sub-total.

I double-clicked on "Dept" and it showed that the sub-totals were set at
automatic but it still does not display.

Thank you in advance for your help. It would be greatly appreciated

Those are two different data fields, so they won't create a subtotal.
You could create a calculated field to add the Salary and Shift Prem
fields. (On the PivotTable toolbar, choose
PivotTableFormulasCalculated Field)

Or, add a column to the source data, where you add the amounts in Salary
and Shift Prem columns, and add the new field to the pivot table.

LaNaveau wrote:
Dept is the only row.
No columns.
Data area:
Sum of "Salary"
Sum of "Shift Prem"

So there will be an amount for Salary and an amount for shift prem by each
Dept. I am missing the total of the Salary and Shift prem by Dept which is
the 3rd line for each dept.

Example:
Dept
700 Sum of Salary 1000.00
Sum of Shift Prem 500.00

What is missing is Total for Dept 700 1500.00 on the next line.

If it helps, I could send the pivot table.

Thanks.



"LaNaveau" wrote:


I lost my sub-totals in my pivot table.
I was trying to do a summary by dept of wages, shift prem and other. Then
for each dept I would get a sub-total.

I double-clicked on "Dept" and it showed that the sub-totals were set at
automatic but it still does not display.

Thank you in advance for your help. It would be greatly appreciated



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

That works!! Thank you!!

"LaNaveau" wrote:

I lost my sub-totals in my pivot table.
I was trying to do a summary by dept of wages, shift prem and other. Then
for each dept I would get a sub-total.

I double-clicked on "Dept" and it showed that the sub-totals were set at
automatic but it still does not display.

Thank you in advance for your help. It would be greatly appreciated