Count If with multiple deminsions

[#1]

Thanks in advance.

I need to count distinct deminsions where if one of three deminsions occur - then it would count as one..and in the chart the total would also sum.

This is giving me the correct totals, however it's not summing at the top of the chart (table)

=count (DISTINCT HCP_Weekly_Writer or HUB_HCPID or if(ProgType__CNE,'Patient',HCPID__CNE))

Need to get a count of anyone that EITHER Was a Weekly Writer, had one or more HUB submissions, or had a Prog with a "Patient"

Thanks in advance!

[Anil_Babu_Samineni]

When you talk about multiple dimensions used then i always prefer to use Flag. and then use simple flag for that?

[#3]

ok cool...haven't created flags in the past...do you do it on the load or how would you create this one?

Thank you!