Total # of calls/records each client opened per day and from these calls breakdown by # of calls opened by same agent per each client on the same date.

Basically i want a breakdown by each Client / # of Calls / by date / by Agent.

For instance,

Jane Smith called 3 times on Monday, 2 times on Tuesday and 4 times on Friday, in a week she called 9 times in total. Out of these 9 calls 3 calls were opened by agentA on Friday and this same agentA opened 2 calls for this client on Monday. The rest of the calls were opened by various agent.

So, my result should show 2 calls opened on Monday and 3 calls on Friday opened by this agent for the client Jane Smith.

Client               # of Calls         Date                 By Agent

Jane Smith       2                      Monday                        AgentA

Jane Smith       3                      Friday               AgentA

This sounds simple but I know it’s complicated. I desperately need help to come up with a formula to meet this requirement.