View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Kline[_2_] Don Kline[_2_] is offline
external usenet poster
 
Posts: 28
Default 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.