Matrix Table Possible?

Summary

Create a table where intersection of Column Value and Row Value is based on another field

Content

Hello,

I am attempting to create a Matrix style table where the Column is represented by a value such as an Account (as in a general ledger) and the row is based on a Fund Value.  The intersection would display the amount for the row and column value.  Here is an example:

 

Fund                                    Account1                 Account2                      Account3

0100X                                  net Balance             net Balance                 net Balance

0100Y                                  net Balance             net Balance                 net Balance

 

For example, the intersection of 0100X and Account1 would display an amount for the net Balance.  The intersection of 0100X and Account2 would display a diffferent net Balance and so forth.