Pivot Table Sub-Totals

[Guest]

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]

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

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

 

[Guest]

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.

 

[Debra Dalgleish]

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
PivotTable>Formulas>Calculated 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.

 

[Guest]

That works!! Thank you!!