I am looking to create a table with the count of distinct reports between two times.
–Example–
TIK-1 – Reporter (John Doe)
TIK-2 – Reporter (Mark Stock)
TIK-3 – Reporter (John Doe)
TIK-4 – Reporter (Chris Twain)
TIK-5 – Reporter (Mark Stock)
TIK-6 – Reporter (Bob Foss)
TIK-7 – Reporter (John Doe)
Count Distinct Reporters - 4
–END OF EXAMPLE–
Right now I use this Count(DISTINCT([Reporter].CurrentMember))
but this does not give me the correct result.
Thanks for any help!