Skip to main content
DD-HLT-004 Hospital Network Performance and Capacity Planning Get the data →
DD-HLT-004-Q034 Hard Time series

Departments explaining 80% of growth in contribution before overhead

For latest-year growth in contribution before overhead, identify the smallest set of departments explaining at least 80% of positive growth. Exclude declines from the denominator, show their combined decline separately, and reconcile to net growth.
Expected
Sorted positive department changes, cumulative positive share, cutoff set, decline total, net change · Variance bridge
Tables
FactHospitalEncounters, FactBilling, DimDepartment, DimDate · columns
  • FactHospitalEncounters
  • FactBilling
  • DimDepartment
  • DimDate
  • BilledSAR
  • DirectCostSAR
  • EncounterID
  • DepartmentID
  • AdmissionDateKey
  • YearMonth

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in.