To calculate the number of services per client, you can use an LOD like this
That will become your first column. Everything else you need are simple calculations. I've included everything in the attached workbook on the "answer" tab.
Let me know if you have any questions.
I tried to do it using Fixed LOD function. Take a look at the attached workbook to see if this is what you are looking for and then if you have any questions, I can walk you through calculations.