close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()