I'm sure this is easy but I am having trouble getting my head around it.
I have a table based on the following :
Clientpurchase dateorder number
A nov 051
Anov 042
Bjul 053
Bnov 054
Cmar 045
Cnov 046
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?
--
Hope this helps,
MarkNquot;Vabu3184quot; wrote:
gt; I'm sure this is easy but I am having trouble getting my head around it.
gt;
gt; I have a table based on the following :
gt;
gt; Clientpurchase dateorder number
gt; A nov 051
gt; Anov 042
gt; Bjul 053
gt; Bnov 054
gt; Cmar 045
gt; Cnov 046
gt; C jul 05 7
gt;
gt; I have created a PT that counts the number of orders by each client eg.
gt; A 2
gt; B 2
gt; C 3
gt;
gt; But I would like to be able to count the number of clients who have
gt; purchased once, twice, three times etc. So I guess I am trying to count the
gt; totals from the count of order numbers - but I cannot seem to get it.
gt;
gt; thanks
- Oct 05 Fri 2007 20:40
pivot table question about count and totals
close
全站熱搜
留言列表
發表留言