in the analysis I have two columns, the task and the average time of the task (the average of the task it's a messure calculated on rpd avg(task_time)). So the analysis looks like:
task. Average time
the grand total it's the average of all the records but what I need is the grand total be the sum all average time (10+15+20 = 45) .
how I can do the above ???
add one more crieteria(combine similar request). Copy your criteria and in the tast column simply hard code 'Grand total' and format the row as you wish. this will do.