Hi,
I am trying to summarise data by a field called StatChoice.
| StatChoice |
|---|
| Email |
| Phone |
| Yes |
| No |
This field contains varied answers which I need to combine, for example count the number of Cases which have an 'Email' flag
The expression works when in a textbox when I use:
=(Count(Distinct{$<StatChoice={'Email'}>}Case)
However, I want to summarise this further by counting the number of cases with an 'Email' flag and a response of 'Yes'
Any suggestions on how this can be achieved?
Thanks,
Paul
