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
|