You can add a field to the source data, as described he

http://www.contextures.com/xlPivot07.html#Unique

and use that field to count the divisions per client.


JohnV wrote:
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



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html