You can try a custom calculation just for your average passing rate, which you can add to Level of Detail shelf and then use in reference lines.
The formula should be something like:
Hello Dimitri. Thanks for the reply. Actually the problem is i'm getting an average of the averages; even if i used that calculation, I would have to chose from the following drop down:
And for my passing rate percentage, the
is the calculation that I am using
Does the AVG produce incorrect values?
Can you post a sample workbook? There might be a better way, i.e. table calculations.