I am new to the reporting web studio and am having problems with the formula to sum all entries in a column. It would appear to be as simple as sum(column[A]) (or sum(col[A]) or even sum([A])) but all I get is the value in the first row in column A, and in the last column of the report the value in the last row. What am I doing wrong?
For example, I have data in A1, A2 and A3, B1, B2, and B3 and C1, C2, and C3, sum ([A]) gives me the value in A1, and sum ([C]) gives me the value in C3.