9 Replies Latest reply on Mar 27, 2018 5:24 PM by Patrick Myles

    Find dimension member by maximum value of measure

    Patrick Myles

      Hi all - I'm trying to do the following:

      Pull out the dimension member name by the maximum value of given measures.  Below is an example of find the top name by the field 'active' in the recent month.  I want a table which includes the max values of other measures some of which are calculated fields

       

      I want the table to look as follows:

       

      Max Active = [agent 488]

      Max Adds = [agent xyz]

      Max Incoming (1Y): [agent xyz]

      etc

       

      Attached is the workbook. does anyone have a nice way to do this?