Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find next occurance | Excel Discussion (Misc queries) | |||
Occurance Counting | Excel Worksheet Functions | |||
Occurance Number Within a String | Excel Discussion (Misc queries) | |||
Need Formula for Last Occurance | Excel Worksheet Functions | |||
frequency for each occurance | Excel Worksheet Functions |