6 Replies Latest reply on Sep 16, 2016 11:05 AM by David Li

    Rolling Calculations but Only Show a subset

    michelle.smith.2

      I have some data that I need to do a rolling 12 month calculation on.  I am using the moving calculation table calc, but I can't seem how to hide the beginning portions of the data where I don't have a full 12 months (in the attached example I only want to show the data starting at Jan 2013).  I'd prefer to do it without changing the axis so some sort of calculated field or filter would be great.

       

      Thanks!