occurance, pivot

[Guest]

Hi,

I have a data as per below

Customer Invoice Charge Type

Adidas 851245 Basic
Adidas 851245 documentation
Adidas 851245 transportation
Adidas 851244 Basic
Adidas 851244 documentation
Adidas 851244 transportation
Nike 851243 Basic
Nike 851243 documentation
Nike 851243 transportation
Nike 851242 Basic
Nike 851242 documentation
Nike 851242 transportation

When i did pivot table i get below result,
Customer (count of) Invoice
Adidas 6
Nike 6

Please is there any way to get a pivot analysis as per below,

Customer Invoice
Adidas 2
Nike 2

 

[Debra Dalgleish]

You can add a field to the source data, and use it to calculate the
unique count in the pivot table. There's an example here:

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

For your example, you could use the formula:

=IF(COUNTIF($A$1:A2,A2)>1,0,1)

 

[Guest]

thanks its works
--
Sincerely Yours
Haviv

You can add a field to the source data, and use it to calculate the
unique count in the pivot table. There's an example here:

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

For your example, you could use the formula:

=IF(COUNTIF($A$1:A2,A2)>1,0,1)