Jump to content

Count OVER multiple columns with limitation from another column

Tymoteusz Grzybowski

Recommended Posts


Data set contains calls per employee to clients from whole year.

Columns from dataset:

Employee Full name; Call date; Year; Month; CALL_ID; ACCT_CNTCT_ID

How to modify this formula

Count([CALL_ID]) OVER ([Employee Full name],[ACCT_CNTCT_ID])

to receive:

- number of calls (CALL_ID)

- from Employee (Employee Full name)

- to client (ACCT_CNTCT_ID)

- which were delivered from February

Thanks for replies.



Link to comment
Share on other sites


something like this:


when ([Month]>1) and ([Year]=Year(DateTimeNow())) then

Count([CALL_ID]) OVER ([Employee Full Name],[ACCT_CNTCT_ID])

else 0

end) OVER ([Employee Full Name],[ACCT_CNTCT_ID])

where the Max() around the CASE is to avoid having rows with zeroes where the condition is not satisfied. I am assuming Month is an integer, if not you will have to turn it into one, and that you want current year only.


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...