Pivot Table Sub-Totals
 

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

Pivot Table Sub-Totals
 

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

Pivot Table Sub-Totals
 

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

Pivot Table Sub-Totals
 

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

Pivot Table Sub-Totals
 

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