Count OVER multiple columns with limitation from another column

Hi,

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.
Greetings,
tymek

(1) Answer

Login