Hello I have a problem regarding the summary function.
As attached picture shown, there are a few columns in the table.
Focusing on the summary row, we can see that there will be 3 summary row in the picture.
So excluding the last column, the summary row should be sum up all the above value.
For the last column, the first and second summary row will be fixed/ the same (So i using average to let them be fixed), that is the value of 102 and 62.
The problem is I would like to sum up 102 + 62 = 164 in the last summary row for the last column which same as the previous summary field. However, I am unable to do this / i dont know how to do this.
The value remain 102.
Anyone know how to output my desired answer? Or is there any things go wrong with my query?
Thanks in advance.
Try set a higher solve order for [Target Overall UPT] than [Summary] column i.e. solve order 1 for [Summary] and solve order 2 for [Target Overall UPT].
Thanks for the reply.
I have set the value of [Target Overall UPT] solve order as "2"
And all the summary row solve order as "1".
However, There will be no output value shown in the summary row for the [Target Overall UPT] (last column).Others filed remain unchanged.