2 Replies Latest reply on Jun 10, 2018 6:50 PM by Jon MacMIllan

    Max value based on multiple dimensions

    Jon MacMIllan

      I am trying to set up a formula that would find the max value of a field by state and only return that value. I have that working properly, but I want to be able to add multiple filters and once I filter it seems to break. The formula I am using currently is:

       

      IF ([Percent Working 10 Years After Entry])== ({FIXED [State]:MAX([Percent Working 10 Years After Entry])}) THEN [Instnm] ELSE NULL END

       

      This returns the college name that has the highest job placement rate by state. I want to be able to filter this by at least two additional fields and I have tried a couple of things, but cant seem to figure it out. I attached the workbook. I appreciate any guidance