3 Replies Latest reply on Jul 23, 2018 11:41 AM by Krishna Mummaneni

    Using LOD to get MAX(count(Id)) among locations even though filtered for another location

    Krishna Mummaneni

      Hi,

      I am struggling to create a LOD variable to get MAX(count(Id)) across all locations even though filtered for another location.

      Example data set is:

      Id     Loc

      1     A

      2     A

      3     A

      4     B

      5     C

       

      Now when i am filtering the sheet/workbook for Location C, I should be able to get the value 3 i.e. MAX Count of Ids among all locations.

       

      Any advice/idea is appreciated.