Matrix or Table Please Help

[awawaw]

Hi guys

Recently, I'm trying to build a report that contain Officer, Company and Number. Like this:

the problem I have is when I using matrix (I put Officer and company in rows), it will merge all the rows with same company name like row 7 & 8 will merge into one row. Btw, I put count Officer in value, so that matrix will provide me the total company count. 

Another way, I tried to use table, but it can not expand or collapse also, I don't know how to add the total company count for each officer. Please help me.

Thank you so much

[tom480]

Here's the PBIX if you want to see all the visual parameters.  Tom

[tom480]

Hi @awawaw ,

There's a lot of ways to do this, here's one idea:  In my example table, I added a transaciton ID to each row (to represent a loan transaction).  From there, it works in the matrix with subtotals displaying each transaction (aka row).

If this is helpful, please mark as a solution to help others find solutions too!  Always glad to help!  Tom 😀

I added a transaction ID to each row to make the matrix work the way you wanted

[tom480 · Accepted solution]

I actually like this view better.  I put the borrower in the values and then made the borrower subtotals white to "hide" this against the background.  Enjoy!  Tom

[awawaw]

Hi Tom, I still have a question. Is there any way that I can make the value align center but still make subtotal as white (invisible)?

[awawaw]

Hi Tom

This was amazing! Thank you so much!