Finance needs to perform month over month forecasting by extrapolating amortized costs based on historical rates. Having this data enables Finance to create amortized cost models.
SELECT MONTH(BillingPeriodStart), ProviderName, ServiceCategory, ServiceName, ChargeCategory, SUM(EffectiveCost) AS TotalEffectiveCost FROM focus_data_table WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ? GROUP BY MONTH(BillingPeriodStart), ProviderName, ServiceCategory, ServiceName, ChargeCategory