Pivot Table Sub-Totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...
 
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.
 
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.
 
Back
Top