4 Replies Latest reply on Jun 27, 2012 7:19 AM by Mark Isaacs

    Multiple Levels of Reference Lines

    Mark Isaacs

      I have a basic viz showing a measure (Total points) broken down by several dimensions (competitor, season, and game).  I've added reference lines to show the average points per competitor, per season.  I would like to also add reference lines that show the average points per competitor (ie, across all of the seasons).

       

      The options available when adding basic reference lines don't appear to support this.  Is there any way to accomplish this through the use of calculated fields, possibly with window calculations?

       

      I've attached a packaged workbook that shows the basic reference lines.  If anyone can suggest how one can add additional reference lines at higher levels (but below the overall table average) it would be greatly appreciated!