Pivot Table Layout

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.
 
R

ryguy7272

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

Don Kline

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top