3 Replies Latest reply on Oct 6, 2017 12:25 AM by Neil Lord

    Calculate lagged values between two sets of data

    Fran Tesorero

      Hi, trying to solve this equation that I use in Excel in Tableau to calculate a  3 month average of one set of values and then lagged 3 months against another set of values.  The excel formula is

       

      =SUM(L3:N3)/SUM(I2:K2)

      Attaching a sample of what I'm looking for.  Thanks for the help.