pivot table question about count and totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Have you tried dragging the client field into the row fields area and then
dragging the another client field into the data items area?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing for every change in a pivot table 1
Pivot Table Sort 4
Count the highest number of days without “errors” 2
Counting number of items excluding duplicates. 1
Calculating total amount in a Pivot Table 1
Pivot table 3
2 dimensional date sort 1
Counting with Excel 4

Back
Top