Saturday, February 15, 2014

yogi_Compute Number Of Customers By Manager For Each Month of The Specified Year

                                         Google Spreadsheet   Post  #1532
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-15-2014
post by Lionel COSTE (https://mail.google.com/mail/u/0/#inbox/1443155617221cc4

The aim of the exercice is to count customers who are involved between startDate and endDate, pivot by Manager. The difficulty belongs in the fact that the pivot table may have each month/year a count for the Managers. Each contract "on Air" must be counted for each month of it's period..
---------------------------------------------------------------------------------------------------------------------------------------------

based on my understanding of the intent in the question, I present here a solution to the problem