Sorry, not sure I understand your question.
In sheet one I have shown a reference line based on the median of the text score of all schools.
In sheet two I also want a reference line but based on the % of students who get a test score of 40 or above for all schools.
So the question is:
How can I show a reference line based on a table calculation for all schools that is not affected by the filters I have in the sheet.
Thanks very much, that's great
You are welcome.