Matrix Table Possible?
SummaryCreate a table where intersection of Column Value and Row Value is based on another field
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.