Sum a column
I have following fields in a temp table and the business view is based on this table"
F55XXXX
A* B* C* D E@
1 W X 1 Z
2 K L 6 Z
3 P Q 8 Z
4 H I 2 N
5 R S 9 N
Where A,B,C with * are primary keys and E with @ is the sorted column.
Now I want to print the totals for D wherever the the value of E@ changes. In the above example the changes happen in row 3 and row 5 (last row). The report should print following:
E@ Total D
Z 15 (1+6+8)
N 11 (2+9)
I have tried using the following:
Where BC E = PC E