Pivot Table - Count distinct values within a group
Posted by Daniel on September 25, 2001 2:00 AM
Hi,
Is there a way to count the distinct occurrancies of a value within a group? For example how many different customers. Here's some some sample data:
Customer Period Amount
A 1 10
A 1 12
A 3 11
B 1 15
B 1 11
B 2 13
B 3 14
C 3 10
Pivot Table:
Customer (All)
Sum of Amount
Period Total # of Customers
1 48 2 <=<br>2 13 1 <=<br>3 35 3 <=<br>Grand Total 96 3 <=<p>Is there a way to create a formula/calculated field to get the # of customers as shown above?
Any ideas are greatly appreciated.
Daniel