Doesn't previous post work enough ?
Thanks this is more like what I was looking for,
You are welcome.
Sorry for late reply.
One more question.
In order to make it user friendly, any way we could accomplish a table that looks like this? Much easier to understand for any audience.
Android + iOS
Android + Windows + MAC
Android + iOS + MAC + Windows
Android + Windows
iOS + MAC + Windows
this is what I can get with the latest approach...not very user friendly...
That's fair request.
Need to create all calculated field as below. and add header of "Users"
[Android + iOS + MAC + Win]
SUM(if [User iOS]<>"Null" and [User Android]<>"Null" and [User MAC] <>"Null" and [User Windows] <>"Null" then 1 END)
"MIN(Number of Records" are kind of frame to put numbers.
Seeing tiny delta from last version, but I have not investigate of cause....Sorry.
Device_Data_9.0_3.twbx 326.2 KB
I was able to fix the discrepancy by modifying the formulas like this:
SUM(if [User iOS]="iOS" AND isNull([User Android]) AND isNull([User MAC]) AND isNull([User Windows])then 1 END)
SUM(if [User iOS]<>"Null" AND isNull([User Android]) AND isNull([User MAC]) AND isNull([User Windows])then 1 END)
Now the amounts are peperfect.
Thank you again. You helped me a lot.