Problem with count in report

[Lucinda_Mason]

I’m trying to get a count per user and I can’t figure out how to get it to work.I’m sure that I’m missing something basic. I think the first column is correctly returning the unique users. Now I need to figure out how to show how many requests were created by each user.

Thanks for your help.

[anonymous]

Try

<<COUNT(SELECT(USERS[USER_NO],AND(IN([USER_NO],REQUESTS[SUBMITTER_USER_NO]),ISNOTBLANK(REQUESTS[PR_NO]))))>><<END>>

[Lucinda_Mason]

Thanks Jonathan. That gives me the sum total on each line, not the breakdown by user.

[anonymous]

Ok, well without any additional info Im not sure. Just seen you forgot the And()

[Steve]

Try:

<<COUNT(FILTER("REQUESTS", AND(ISNOTBLANK([PR_NO]), ([SUBMITTER_USER_NO] = [_THISROW-1].[USER_NO]))))>>

[Lucinda_Mason]

Thanks Steve. It worked perfectly.