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

    Summing only Max Values in set Analysis

      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



        [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