I'm trying to add a nested table to my detail view.
I have table allEnrollments w/ key productId. (Accounts have an id [BAC]).
I have table dwcEnrollments w/ key productId. (accounts have an id [BAC]).
When I click on a product record of dwcEnrollments, I want to show a list of allEnrollments products where the bac is the same. (One product ID is tied to a BAC, a BAC has many products)
I have tried to create a ref column, but the related field that is autocreated uses the key of the table. I need instead to use the BAC. So my question is "How do I use a column that is NOT the key of the table to create a nested table on the detailed view?" I have seen some people mention 'use select', but I'm not real sure where I should put that, should it be put in the 'related x' autocreated column?
Solved! Go to Solution.
I accidentally solved my own problem.
in the ref column, instead of REF_ROWS(), I used the following formula
SELECT(allEnrollments[productid],[_THISROW].[bac]=[bac])
I accidentally solved my own problem.
in the ref column, instead of REF_ROWS(), I used the following formula
SELECT(allEnrollments[productid],[_THISROW].[bac]=[bac])
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |