We've been building custom reports like this with Google Apps Script in Google Spreadsheets for customers since 2010. This is the first time our work has shown up in the forums. Thank you Carl for sharing this!
"wow - I guess Interlockit have some wizardry in their team! Nice report - this is exactly what I need."
--Q
"These custom reports are a really nice touch. Well done to interlockit for demonstrating this capability."
--davieboy
"Just superb for management reporting and KPI tracking - forcing the “so what?“ question much more than you might expect."
--Carl