Variance Analysis with dynamic version selection
I'm trying to pull specific data based on the version selected by the user. I tried using Lookup and Select but didn't work. Any smart ways to fetch the specific values from the selected Version dynamically?
The table where User can select the Base or Compare Version - this is from the list items
Trying to fetch data from another table for Variance Analysis Calcualtions.
This is the list of Versions
Compare Version General List
Base Version General List