4 Replies Latest reply: Jul 24, 2012 12:41 PM by Rodney Ray RSS

    Another max row question

      I have been looking through the form to solve my max row problem, I think I'm close, but still not getting it! This is what I'm trying to do

       

      I have campus 1, and 2 (column called campus)

      I have Units ICC,OR,ER .. many more (each unit may or may not be on both Campuses)

      Each Unit has many rows with a update, and a archive_id for a single day.

       

      I can get the max archive_id by using the function =aggr(max(ArchiveSnapshot_ID),campus,Unit_Name) as a Dimension.

       

      What I'm not getting is a expression (I think) that will display the max row, per campus , unit based on the selection. If no selection is made when opening the doc I would like to see all max rows for each campus/ units. Again each campus may or may not have a the same unit.

       

      Example

      Campus,  Unit, Update, Archive_id

      -----------------------------------------

      campus 1, ER ,7/29/2012,12

      campus 1 , ER, 7/20/2012. 23

      campus 1, OR, 7/20/2012 9

      campus 2, ER ,7/20/2012, 15

      campus 2, ICC,7/20/2012. 34

      campus 2, ICC,7/20/2012 36

       

       

      Display should look something like this:(default) unless 1 or more units are selected, then only those units will be displayed

      campus 1 , ER, 7/20/2012. 23

      campus 1, OR, 7/20/2012 9

      campus 2, ER ,7/20/2012, 15

      campus 2, ICC,7/20/2012 36