Pivot Table Layout

  • Thread starter Thread starter Don Kline
  • Start date Start date
D

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.
 
Double-Click the field and click ‘none’ in the columns you DON’T want to see
a subtotal for.
 
Thanks for your help. I'm good to go.

ryguy7272 said:
Double-Click the field and click ‘none’ in the columns you DON’T want to see
a subtotal for.
Click to expand...
 
Back
Top