1 Reply Latest reply on Dec 31, 2013 11:57 AM by Joshua Milligan

    Sum values based on MAX date value-Multiple Years

    Lauren Vidak

      I am working with employee headcount data and I want if to sum my active headcount variable when it is the max date for a particular year. I want Tableau to sum headcount if max date in 2012, 2013 and eventually 2014. I've been trying to create a MAX[date] and compare to as of date, but that is not working. Any suggestions? I am a very new user so my experience level is "new". Thanks in advance for your help

       

       

       

      SUM(IIF([asof]=[MAX-2013],[active],0))