3 Replies Latest reply on May 8, 2012 5:12 AM by Jonathan Drummey

    Reference lines at a level between entire table and pane?

    Aaron Medema

      Does anyone have a trick for adding a reference line at a level between the entire table and the immediate pane?

       

      I'm building a bar chart and in the row shelf I have Grade, then Class, then a couple of fields with additional details specific to each school (teacher, class size, etc.) and my measure is median test score per class.  I have a reference line for the whole table that shows the median across the whole school, but I would also like a reference line for the median per grade.  If I only have Grade and Class fields on the row shelf then the reference line per pane works great, however when I add more fields showing necessary detail for each Class to the row shelf, then "pane" no longer goes back to the Grade level since it seems that "pane" is just one level back in the shelf.

       

      Thanks!