Count If Question

[#1]

Hello again,

a small Question this time:

I have an table with Employee, Customer ID, Date of visit and a Column "X". Looks like this:

Employee - Customer ID - Date of Visit - X

hhhhh          676762          01.06.2012     +

jjjjjj               586566          02.06.2012.     -

....

The Column "X" contains +, -, K or P. In a straight table i want to add an calculated field that counts the "+" or "-"....(One customer can have more than 1 visits).

My Question: How the formula looks like to count for every Customer the amounts of "+", "-"?

Thank you for your help

[Miguel_Angel_Baeyens]

Hi,

Did you try using set analysis? In a new chart, type straight table, the dimension should be Customer ID, and the expression something like

Count({< X = {'+'} >} [Customer ID])

or

Count({< X = {'-'} >} [Customer ID])

Hope that helps.

Miguel

[#3]

Hello,

unfortunately it doesnt work for me. Your formula gives me only "1" as a value. But in my table are 13 "+" values for this customer. The fornula should show me the value 13 for this customer.

Kristian

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Try instead

Count({< X = {'+'} >} X)

Hope that helps now.

Miguel

[#5]

Thank you a lot.