How Could I do this ratio?

[ecabanas]

I have this example table:

SalesId   CustomerID   date

1             A                   jan-12

2             B                   Jan-12

3             C                   Jan-12

4             A                   Feb-12

I want to know the number of salesId which has ben bough two times

count({<SUM(count(SalesID))>=3>} CustomerID)

thank's to all

[#2]

i didn't get you properly.. plz describe briefly what you actually  want to do....

[ecabanas]

I want to know, how many customers has been bought two times, in my example: 1

The customerID: "A" has bought two times, the rest only one!!!

[#4]

CustomerID	count(SalesId)
A	2
B	1
C	1

step --1-- use pivot table

step 2--   take dimension CustomerID

step 3--  add expression count(SalesId)

hope this will help you

[ecabanas]

Hi!!

This will not be possible, I need this number in a text box, has to be a function!!

Sent from my iPhone

[#6]

in which sheet object you want to see the output.?????

text box mean ?

[ecabanas]

yes, in text box

[#8]

see the attached image.

hope this will help you..

[ecabanas]

YES, and how you did it?

How you filter the pivot and how you conect the pivot cell with the text box?

Thank's

Eduard

[#10]

Hi,

As I understand you query, you are trying to find out how many CustomerID have purchased more than twice.

This cant be done using a a function in a text box. Max you could do is, display the count of the number of time the selected customer has purchased.

I have compiled an QVW with an example of how you could do it.

Let me know if this is what you are looking for, else let me know you exact query with sample data

thanks

Fahad