ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Pivot table and counting totals (https://www.excelbanter.com/excel-worksheet-functions/89796-pivot-table-counting-totals.html)

Vabu3184

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



All times are GMT +1. The time now is 09:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com