Hi Cindy, check out my attached workbook. The issue with just adding a reference line here is that you don't want an average of all the percentages, it needs to be a weighted average. So I created a new calculation 'Ref Line Calc' that computes the weighted average for this view using a Level-of-Detail expression. This allows for summing across all the lines to get the total percentage. Then I used that value for the reference line.
Hope this helps!
Cindy Test Data.twbx 52.1 KB
That is perfect! The reference line comes in at 19.4% which is the value on the report.
Thankyou Thankyou Thankyou!