XLs pivot running toltal 1

[Matsul]

Is there a way of disabling the running totals in an excel pivot table ?


Pivot
-----
Sum of Count
Total
MM a 30
MM Total 30 --> Not Required
PP a 10
d 10
PP Total 20 --> Not Required
RM a 50
d 30
RM Total 80 --> Not Required
Grand Total 130



Data (to create above pivot)
-----

Rp Status Count
MM a 10
RM a 20
Rm a 30
MM a 20
PP d 10
RM d 30
PP a 10

 

[SkipVought]

Hi,

Double-click the Field Heading in the PT, and change the Subtotals Option Button to NONE.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}