Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi,
Try instead
Count({< X = {'+'} >} X)
Hope that helps now.
Miguel
Thank you a lot.