Alright so this is similar to some of the other questions I see on here routinely but it goes 1 step further.
I first want to know how many customers played from multiple devices, but I then need to break out what device combinations were used and what the counts were respectively.
Example data:
Sess # Acct# Device
1 001 A
2 001 B
3 001 C
4 002 A
5 003 B
6 002 B
7 004 C
...
Desired output:
Device Combo CountDistinctUsers
A 0
B 1
C 1
AB 1
AC 0
BC 0
ABC 1
...
I have a total of 7 devices. So If this has to be done using a case statement and series of Calcs it's not terrible since the device list is limited. There can only be 1 device per record so the combo output is a concatenation of the devices used.
I'm still working on putting together a sample workbook with some example data, but any help would be appreciated.
Thanks,
Josh
