[AI-436] refactored drill down to use pivot sites so that monthly reports are included