I have a requirement where in business wanted Tableau UI to -
1. List down the measure variables across 3 categories and
2. Use selected variable to dynamically calculate the score at row level (mathematic function include Min, Max and log of)
Category 1 : V1, V2,V3
Category 2: V4,V5, V6
Category 3: V7, V8, V9
Source data structure: V1 till V9 measure values.