Right-click on the data cell and select "Add Total", then right-click on all rows of data and change its visibility to "Hide." That should do the trick!
EDIT
Step-by-step setup guide with image:
The first example image: on the left is the result you want, on the right is the result obtained from a simple grouping.
I get the sum (but you can use counting or any other aggregation) of the lam_larghezza field (which is width for your information) by a group of different lam_spessore values ββ(which is thickness)
Sorry, but the mi IDE is in Italian, so here is a simple translation:
Aggiungi β Add / Gruppo β Group
Righe β Lines
Raggruppa per β Group
Totale β Total
Dividi Celle β Split Cell
VisibilitΓ Righe β row visibility

Let it begin!
Create a dataset for the report and clear the report
Add table to report

Add details field to data row

Right click on the full line
Add group β Row group β father's group β group by grouping fields (must be of age)


Click on the detail cell (only the cell is not the entire row, and remember that the cell should have been selected not with text inside the cell, since two different context menus are displayed) β Add general

Now you have 1 grouping cell and two cell details
split cell grouping field

set the visibility of the detail line to hidden

And you're done!

source share