Sum of SSRS in the table

I am working on SSRS reporting services. I have a table on which I applied a group. Initially, I had the following data:

enter image description here

I changed something in my tablix and created tablix and added the parent group Age ie left column, and then in the right column, I applied the expression: =SUM(Fields!AgeTotal.Value, "Group1") which made the result as follows: enter image description here

Now I want 3.3,3 and 2,2 not to repeat and make them 1 line of each group. Example: enter image description here

UPDATE: enter image description here

+5
source share
1 answer

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

enter image description here

Let it begin!

Create a dataset for the report and clear the report

Add table to report

enter image description here

Add details field to data row

enter image description here

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

enter image description here

enter image description here

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

enter image description here

Now you have 1 grouping cell and two cell details

split cell grouping field

enter image description here

set the visibility of the detail line to hidden

enter image description here

And you're done!

enter image description here

+10
source

Source: https://habr.com/ru/post/890388/


All Articles