SQL Report Builder 3.0 Merge Rows into a Totalizer column

Question

Considering a simple query where you bring a list of people containing your name, code and age, I would like it to be displayed in the last right column the sum of the ages according to the image (in this example I consider as if each one was 15 years old)

using groups even with you but the group is always at the beginning of the table (left side) would like it to be on the right side, has an option to reverse the orientation of the table, but it looks as if it were mirrored I would have to reverse the position of the fields to be close to ideal however this for a future maintenance would be difficult to understand, I wonder if there is a simpler solution, perhaps with an expression

Answer 1

A solution :

SELECT NOME,
       CODIGO,
       (SELECT SUM(IDADE) FROM TABELA) SOMA_IDADE
FROM TABELA

Some BDS ANALYTIC FUNCTIONS that facilitate tasks of this type.