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

[#1]

I have a straight table as follows

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])

[Anonymous]

please post your source data or qvw file

[#3]

I have uploaded a qvw with sample data. so the goal is to populate the right column with the sum as shown

I have the group total showing - on right column - but it only shows in one row. need it in all rows for group.

Any help appreciated