View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John[_146_] John[_146_] is offline
external usenet poster
 
Posts: 5
Default Pivot Table problem

I have a pivot table with Names in Column A. Columns B, C and D contain data
as follows:

A B C D
Joe 50
Sue 75 25
Sam 25
Tom 30
Fred 20

How do I make my pivot table total each row? (Joe = 50, Sue = 100, etc) I
don't care if a new column is added or if B, C and D are combined in 1
column. I need those totals for my Pivot Chart.