set analysis expression

[Anonymous]

hi there,

ı have a table like that :

ID	YEAR_MONTH	category	money
3969385	201502	car	1.206
3969385	201506	bus	2.455
28289815	201502	x	610
22291674	201506	car	1.224
23481102	201506	t	563
10126853	201508	bus	445
360150	201503	r	1.231
1631437	201511	w	523

ı want to filter ID s like that :

Display ONLY the ID that includes BOTH category = "car" and "bus" 

( here the answer is ID='3969385' that is the one includes both, there are other ID that only inclues one of them that is useless for us)

Anyone can help? thank you.

[sunny_talwar]

May be like this

Sum({<ID = {"=Count(DISTINCT {<category = {'car', 'bus'}>} category) = 2"}>} sum)

[jtay]

maybe this one:   Count({<match(category,'car','bus')>}ID)

[Anonymous]

it says , error in set modifier

[Anonymous]

bad field names : sum

[sunny_talwar]

You provided that field in your data my friend

I guess it would be helpful if you don't provide bad field names: sum

[sunny_talwar]

The set analysis is working... have a look

[Anonymous]

my bad , you are right. ı changed it to "money"

[sunny_talwar]

edit what? what are you trying to edit?

[Anonymous]

ok ı fixed it . edited.

can you write the formule accdng to that please