Insert sub-total per page into a RDLC Report (.NET) table

Question

I need to insert cumulative sub-total on each page of my RDLC report. NET, I am using a table to allocate all the values of the fields and their summations.

The great difficulty is to insert the total inside one of the cells of this table.

Answer 1

You need to add new groups to your tablix, in the Detail section and within the Row Groups of your table. You can create as many clusters as you want.

Hence you can define the partial sums and totals by these groups. You can also make formulas in your fields, like:

=sum(Fields!Campo1.Value)/CountDistinct(Fields!campo2Agrupado.Value)