Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
please post your source data or qvw file
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