Set of Summations group by key column.

[jimyWeb]

Hello!
I have a datasource and I want to make several summations grouping the data by a column. I do not want to show all rows, I want to show the summations like this:

ValueColumn A Subtotal 1 (Sum of all rows whose key column has value A)
ValueColumn B: subtotal 2 (Sum ... value B)
ValueColumn C: subtotal 3 (Sum... value C)
..................
value N: N subtotal

Therefore I can not use DataBand or groupfooterband.
How I can do this set of summations?

Thank you very much.

[HighAley]

Hello.

You could add Summary on the Group Header or Group Footer and set the Height of the Data Band to zero.

Thank you.

[jimyWeb]

Thank you HighAley it works perfectly

[HighAley]

Hello.

We are always glad to help you.
Let us know if you need our help.

Thank you.

[Fabio Pagano]

Hi,
I need help about similar problem.

I'd like to view total of all rows whose column has the same value

I attached a picture of my DATASET, report structure (cattura2) and the result I expect (Opzione_totale).

I used the followind code into field I'd like conditional subtotal:

{SumIf(DataBand2,
DescrizioneLavoroSintetica.Lavoro__Prezzo,
DescrizioneLavoroDettagliata.Lavoro__Note_pubbliche_immagine=="OPZIONE1")}

but not work

any idea about?
thanks in advance.

[Edward]

Hi Fabio,

Your report should work as you have done everything correctly. Please see the simple example of the report attached where the simple aggregate function is used. So please check the name of the Databand, was it definitely DataBand2?

AggregateByCondition.png (230.75 KiB) Viewed 2639 times

AggregateByCondition.mrt

(672.22 KiB) Downloaded 162 times

Thank you,
Edward