I have a question regarding reflecting a selected value of a parameter in a calculated field.
The data is simple, ID is unique and tied to X( a number). The task is to create a calculated field to reflect the selected ID's X value across the table. Example I have selected a1 which have a X value of 4, I then tag 4(calculated field) to the entire table.
I am able to do this using WINDOW_AVG but now I need an answer without using table calculation.