Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Matrix or Table Please Help

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 merg...
Need Help
  • tom480's avatar
    tom480
    4 years ago

    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

     

tom480's avatar
tom480
Icon for Resolver I rankResolver I
4 years ago

Hi Anonymous ,

 

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's avatar
tom480
Icon for Resolver I rankResolver I
4 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Tom

    This was amazing! Thank you so much!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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)?