4 Replies Latest reply: Dec 7, 2016 5:16 AM by James Whitmore RSS

    Summing only Max Values in set Analysis

    James Whitmore

      Morning all.

       

      I have a Set Analysis that works well when I filter the table as we only want to show the Max value for a certain Division or Site, My client now wants to include multiple Division's and want's to Sum all the max values I have tried

       

      =SUM(aggr(MAX({$<

        [Activity Conversion Key]  ={'FloorArea'}

        ,[Activity Period Year]={$(vYearFilter)}

        >

       

        }

        num([Activity Value],'#,##0.000'))

       

      But it does not work.

       

      I have attached an excel of the data