1 Reply Latest reply on Jul 12, 2017 11:03 AM by Patrick A Van Der Hyde

    Limit to 3 months BEFORE beginning of last month in data set

    Alex Martino

      How can I create a formula that looks at last date in data, goes to the end of the prior month, and then 3 months back from that.

       

      For example, if it's June 10th, I only want 12 months of information through the end of January. So Feb of prior year to Jan of current year.

       

      How can I do that? Thanks.

       

      Also, I want to look at year over year comparisons (so that 12 month look, vs a prior 12 month look).

       

      Thanks.