Pivot Table Layout
 

I'm a little rusty on Pivot Tables. This is primarily a formatting issue. I
have four criteria which from left to right a 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.

Pivot Table Layout
 

Double-Click the field and click €˜none in the columns you DONT want to see
a subtotal for.

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Don Kline" wrote:

I'm a little rusty on Pivot Tables. This is primarily a formatting issue. I
have four criteria which from left to right a 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.

Pivot Table Layout
 

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

"ryguy7272" wrote:

Double-Click the field and click €˜none in the columns you DONT want to see
a subtotal for.

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Don Kline" wrote:

I'm a little rusty on Pivot Tables. This is primarily a formatting issue. I
have four criteria which from left to right a 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.