2 Replies Latest reply on Jun 7, 2018 8:10 AM by Jennifer Gaskill

    Hierarchical Selection

    Jennifer Gaskill

      Still fairly new, so I don't even know what this would be called. I'm using a data set that has several state rates depending on various populations. I need to pull one response based on a hierarchy. Use the Medicaid & CHIP rate, if there isn't one then use Medicaid Only, then Medicaid, then Medicaid & CHIP & Dual, Medicaid & Dual, and finally CHIP only. So on the attached workbook, for Adolescent Well Care Visit the rate for Alabama would be 42.2 instead of 74.1.