Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vabu3184
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table and counting. sacredarms Excel Discussion (Misc queries) 2 January 2nd 06 02:30 PM
Counting .5 in a pivot table mtcurtis Excel Worksheet Functions 1 September 8th 05 05:56 PM
counting in pivot table Marisa Excel Worksheet Functions 14 August 15th 05 04:58 PM
Counting blank cells in Pivot Table Andy Joyce Excel Worksheet Functions 1 December 21st 04 10:05 PM
Pivot table and counting ChristopherH Excel Worksheet Functions 1 November 20th 04 01:26 PM


All times are GMT +1. The time now is 10:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"