I have 2 tables in my data model: Accounts - the main one and Filters - the one I want to use for presenting data in a given format:
3. Bank Charges
I would like to present the data in sort of the filtered format, where Output=Value * Sign for all the rows from Accounts: table matching the Filter from Filters: table
100*1 + 129 *1
129 * 1
3. Bank charges
The Output table can be several hundreds row long and changing from one month to another as new accounts are added - in my opinion it prevents use of Set Analysis in the Output: chart itself (I may be wrong here, but it's not something I can do manually)
Filters are manual, thus they can have different length.
The account can be 461-1, 461-2 and filter can be 461 or
The account can be 203-1-5, 204-1-5 and the filter can be ???-1-5
My Accounts: table is the core of the data model. Filters table is a manual inline table.
How can I create a connection key to put those 2 tables in relation?