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

--
Sincerely Yours
Haviv