2 Replies Latest reply: Sep 24, 2014 5:08 PM by jim OConnor RSS

    Help total a column and populate each row of another column with total

    jim OConnor

      I have a straight table as follows

      cisco live rank.JPG.jpg

      How can I get the right column to show the numbers indicated?  i.e. it is a sum of second from right column grouped by Job Function.

       

      Currently this the script in right column

      aggr(sum(aggr(   sum(  aggr([Session Overall] ,   ATTENDED ) )

      *  sum(  aggr( if ( [Session Overall]  >= 1  ,1,0)   ,ATTENDED,  )),[Session ID] )) ,[Job Function])