View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JohnV JohnV is offline
external usenet poster
 
Posts: 3
Default Pivot Table Count

Hello. I have a pivot table that looks like

Client Name Div 1 Sales Div 2 Sales Div 3 Sales Div 4
Sales
One Corp 100 200 250
65
XYZ Corp 155 100

Smith & Jones 50 20
75

What I want is to add the Count of Divsions like this

Client Name Divs Div 1 Sales Div 2 Sales Div 3 Sales
Div 4 Sales
One Corp 4 100 200 250
65
XYZ Corp 2 155 100

Smith & Jones 3 50 20
75

Is there a way I can do this in a single pivot table or by combining two
pivot tables?

Thanks,
JohnV