Pivot Table Formatting
 

Hello All

I have created a pivot table and want to format this to remove the
subtotal's below each major total i.e.

Location1
Business Name1
Business Name1 Subtotal
Business Name2
Business Name2 Subtotal
Business Name3
Business Name3 Subtotal
Location1 Grandtotal

Location2
Business Name1
Business Name1 Subtotal
Business Name2
Business Name2 Subtotal
Business Name3
Business Name3 Subtotal
Location2 Grandtotal

Is there a method to do this? I've tried numerous settings in the 'table
options' such as hiding the subtotals and grandtotals.

I'd appreciate any assistance.

Many thanks to all who respond
H

Pivot Table Formatting
 

Please don't respond - I've found the fix.

Just right click the cell with the subtotals and select hide !

Have a good day!

"Hardip" wrote:

Hello All

I have created a pivot table and want to format this to remove the
subtotal's below each major total i.e.

Location1
Business Name1
Business Name1 Subtotal
Business Name2
Business Name2 Subtotal
Business Name3
Business Name3 Subtotal
Location1 Grandtotal

Location2
Business Name1
Business Name1 Subtotal
Business Name2
Business Name2 Subtotal
Business Name3
Business Name3 Subtotal
Location2 Grandtotal

Is there a method to do this? I've tried numerous settings in the 'table
options' such as hiding the subtotals and grandtotals.

I'd appreciate any assistance.

Many thanks to all who respond
H