1 Reply Latest reply on Aug 18, 2016 10:19 PM by Yuriy Fal

    Reference Line Calculation Help

    ann.stolzman

      Hi all,

       

      I've been working with reference lines a bit, and I wanted to know if there is a way to display a reference line that has the sum of one year's sales divided by the sum of the current period sales.  For example, I'm currently comparing sales for the month of June and July of 2015 to June and July 2016.  I've attached a workbook that approximates what I'm doing, and if I add the grand total line, I get the correct approximation of growth, but I want to show that on a reference line instead of the average growth of the individual items.  Is that possible?

       

      Any ideas?

       

      -Ann-