Hi All,
I have a table where cars are evaluated across multiple categories qualitatively. The qualitative scores have numeric score mappings. I want to find how much did each car score numerically across all categories based on the summation of the representative numeric score for each of the qualitative scores. I want to find the "Sum" column score. You may refer to the attached file for more clarity. Thanks for the help