Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i have a field called GROUP, and i want to see whether is there any customer who have bought a product in all the three groups.
=count({<Group={'LIFESPACE','CLUB','FINANCE'}>}Customerid)
but this expression counting all the customer who are in the GROUP irrespective of whether customer bought a product in all the GROUP
how to write a expression which check and count only those customerid who bought a product at least once in all the three diff GROUP
Thanks
Naveen
May be this =Count(DISTINCT{<Customerid = p({<Group = {'LIFESPACE'}>})*p({<Group = {'CLUB'}>})*p({<Group = {'FINANCE'}>})>}Customerid)??
how to write a expression which check whether the customer brought a product in all the Groups or not
plzz
Any Suggestions PLz....
i am looking expression for below requirement
No. of customers who bought life space product also bought CLUB and Finance products in last one year
aircode:
COUNT({$ <Prod = {A, B, C}, MyYear = {2016} >} DISTINCT Prod) = 3
else please supply an example
HTH Peter
May be this =Count(DISTINCT{<Customerid = p({<Group = {'LIFESPACE'}>})*p({<Group = {'CLUB'}>})*p({<Group = {'FINANCE'}>})>}Customerid)??
Can you provide data set and expected result
Thanks Shiva ,it is working.....bang on