If i have a nested select statement of 3 selects in a report (each from 3 distinct tables, table1, table2, and table3), and they all have a field called “Unique ID” that may store different values in each but has the same name. How do i differentiate the field for each table?
Example:
<<Start: Select(Table1[Unique ID], [ABC]=“ABC”)>>
<<Start: Select(Table2[Unique ID], AND([ABD]=“ABD”, [Unique ID]=[Unique ID])>> #The second Unique ID is for the table1
<<Start: Select(Table3[Unique ID], AND([ABE]=“ABE”, [Unique ID]=[Unique ID])>> #The second Unique ID is for the table2
<>
<> <>
Something along those lines…
LinkedIn
Twitter
