Highlight of user that uses different methods to pay/withdraw

[matbelli]

Hi all, i have a problem in doing this: 

ID	idmeth	method
10260336	27	VERSAMENTO RICARICA SUL CONTO
10260336	28	PRELIEVO SU PAYPAL
10260339	27	RICARICA CON PAYPAL
10256565	28	PRELIEVO SU PAYPAL
10256565	27	VERSAMENTO RICARICA SUL CONTO
10256565	27	RICARICA CON PAYPAL

I have to check if these users have used "RICARICA CON PAYPAL" and something that is not "PRELIEVO SU PAYPAL". How can i do that?

Thank you in advance

[Gysbert_Wassenaar]

Try a table with ID as dimension and this expression:
count({<method={'RICARICA CON PAYPAL'},ID={"=count({<method-={'PRELIEVO SU PAYPAL'}>}distinct method)>1"}>}distinct ID)

[matbelli]

Hi, thanks! This works, but not totally.
I mean, this code shows me who used both of them, but not who used one of that and not the other, is it possible to show also the opposite?
Is it possible to distinguish between idmeth (pay=27, withdraw=28)?

update: I tried to do like in the example in the file attached, that formula you posted just counts the first method.

[Gysbert_Wassenaar]

count({<method={'RICARICA CON PAYPAL'},ID=E({<method={'PRELIEVO SU PAYPAL'}>}ID)

count({<method={'PRELIEVO SU PAYPAL'},ID=E({<method={'RICARICA CON PAYPAL'}>}ID)