So the MeasureGroup element would be a repeating element for each group and within each group the Measure element would repeat for each measure that is part of the MeasureGroup. The provider tag would also need to be wrapped around each measure. The measure-group-total element is just a calculation for each measure withing the measure group.
the data is stored in a table like this:
Measure_Group Measure_Number Eligible_INstances Reporting_Rate
A 1 100 100
A 2 110 88
B 3 100 100
B 4 110 100
I'm new to writing the XML using For XML, so the repeating groups and repeating elements within the groups are frustrating me. Any ideas would be appreciated.