|
occurance, pivot
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 |
occurance, pivot
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 he http://www.contextures.com/xlPivot07.html#Unique For your example, you could use the formula: =IF(COUNTIF($A$1:A2,A2)1,0,1) haviv wrote: 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 Contextures http://www.contextures.com/tiptech.html |
occurance, pivot
thanks its works
-- Sincerely Yours Haviv "Debra Dalgleish" wrote: 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 he http://www.contextures.com/xlPivot07.html#Unique For your example, you could use the formula: =IF(COUNTIF($A$1:A2,A2)1,0,1) haviv wrote: 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 Contextures http://www.contextures.com/tiptech.html |
| All times are GMT +1. The time now is 11:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com