Pivot Table Formatting

[Hardip]

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

[Hardip]

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