3 Replies Latest reply on Oct 17, 2016 5:26 AM by ammar.khwaira

    Hide data but not exclude

    Mikey Michaels

      Hi All,

      I hope this message finds everyone well.

      I hope I can explain my question without confusing everyone.

       

      Below is a simple line graph that shows a price per unit calculation (Price / Unit)

      The numerator (or price) is a trailing 12-month calculation, which is why there are 11 periods of blank data before my line graph starts.

      How can I hide these 11 blank periods (2015007 - 2016005) but not have my price per unit calculation change? I tried to simply highlight and exclude, but that definitely affected my overall price per unit calculation.

       

      Unfortunately, I cannot attach my workbook as it contains sensitive information.

       

      Thanks!

      Cheers,

      Mikey