Hello,
I am using a crosstab with formulas to try to get a distinct count based on {Event.key} only if {Messaging.Recipient} like "*PCT*"

I am grouping on the {event.key}.

My problem is there is multiple {Messaging.Recipient} like *PCT* for each event but so I basically I need if there is a PCT under the key then count.

IF {Reports_Messaging_Recipients.FriendlyName} like "*PCT*" THEN DISTINCTCOUNT({Reports_Messaging_Recipients.FriendlyName},{Reports_Events.Key})

Yes, because I have my other results in a cross tab

Its still counting every time there is a PCT underneath the key with the same key. I need it to only count once per key that has PCT in the table.

Thanks for the help!

your process will work but to get any results to function in a crosstab can be tricky.  

Edited by DBlank - 12 Mar 2015 at 6:54am

I spoke too soon. With multiple rows it will not pick up the PCT count. I think the previous is too far before so it nulls them. Any other ideas?

Thanks!