Marisa -

FWIW, I've gotten fairly good at this Access Pivot Table stuff, and I
haven't found a way to do it. If no one else has either, maybe MS should add
this capability to the next Access version!

Kevin

"Marisa" wrote:

I have the data source like below:
product customer quantity
1 A 1000
2 A 1000
1 B 500
3 B 200

and my pivot table like below:
customer product total
A 1 1000
2 1000
A Count 2
B 1 500
3 200
B Count 2

How can I get the number of customer = 2 (A, B)?
and number of product = 3 (1, 2, 3)?
It seems to me that the count on pivot table only count the number of row of
that data.

Can I get this count from pivot table or other excel formula?