Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table and counting totals
NOt sure if this is the right place to post this?
I'm sure this is easy but I am having trouble getting my head around it. I have a table based on the following : Client purchase date order number A nov 05 1 A nov 04 2 B jul 05 3 B nov 05 4 C mar 04 5 C nov 04 6 C jul 05 7 I have created a PT that counts the number of orders by each client eg. A 2 B 2 C 3 But I would like to be able to count the number of clients who have purchased once, twice, three times etc. So I guess I am trying to count the totals from the count of order numbers - but I cannot seem to get it. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table and counting. | Excel Discussion (Misc queries) | |||
Counting .5 in a pivot table | Excel Worksheet Functions | |||
counting in pivot table | Excel Worksheet Functions | |||
Counting blank cells in Pivot Table | Excel Worksheet Functions | |||
Pivot table and counting | Excel Worksheet Functions |