You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Matrix Table Possible?

Question
7
Views
0
Comments
edited May 7, 2019 4:39PM in Visual Builder

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!