Pivot Table Layout

[Don Kline]

I'm a little rusty on Pivot Tables. This is primarily a formatting issue. I
have four criteria which from left to right are: Gender, Smoker, OccClass,
and Period.

Given the four entries, the pivot table is to return the premium for an
insurance policy.

I am getting the right answer. What I want to do is have the "Grand Total"
column be the only column to show the premium. Right now it shows a total for
each of the four criteria.

 

[ryguy7272]

Double-Click the field and click ‘none’ in the columns you DON’T want to see
a subtotal for.

 

[Don Kline]

Thanks for your help. I'm good to go.

Double-Click the field and click ‘none’ in the columns you DON’T want to see
a subtotal for.