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
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
No comments:
Post a Comment