how to write expression

[kunkumnaveen]

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

[kunkumnaveen]

how to write a expression which check whether the customer brought a product in all the Groups or not

plzz

[kunkumnaveen]

Any Suggestions PLz....

[kunkumnaveen]

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

[prieper]

aircode:

COUNT({$ <Prod = {A, B, C}, MyYear = {2016} >} DISTINCT Prod) = 3

else please supply an example

HTH Peter

[Anonymous · Accepted solution]

May be this =Count(DISTINCT{<Customerid = p({<Group = {'LIFESPACE'}>})*p({<Group = {'CLUB'}>})*p({<Group = {'FINANCE'}>})>}Customerid)??

[Anil_Babu_Samineni]

Can you provide data set and expected result

[kunkumnaveen]

Thanks Shiva ,it is working.....bang on