I’ve been asked to setup a table that has a sub total after every department, which I don’t currently know how to do.
I tried this with a Matrix, but they don’t want the items measure to be repeated per department too, just shown once at the end in the column totals.
Is this possible? see pbix file
table help.pbix (22.7 KB)
hI @lavina.bogan ,
Welcome to the forum.
You can use the trick → hide items per department
To do so first you need to
Remove wrap text - both for Values and headers
Then just shrink the value fields per departments until it is hidden.
Example:
table help V1.pbix (24.6 KB)
Hope it helps.
Best regards
Thanks for your reply. I knew about hiding the columns, but I had other columns using wrapped text.
Embarrassingly, the solution was even more simple… I just made multiple tables, each with its own headers and totals together with a Totals table. My clients were happy with the result. It’s not ideal if one table gets more rows, but the solution to that is Report Builder
