I have a table described below with values. I have inserted column references above to better explain the scenario.
I'm trying to reconfigure the dataset for each combination of the fields displaying the multiplied the value.
The number of combinations will be 2X2X3X2X2 = 36 combinations
C and D are Age fields
E to G are fields related to number of drivers
H and I are use fields
J and K are the number of doors in the vehicle.
i.e. C*E*H*J = 0.24
The output should look like the output above.
Note, the example is a subset of the results because it is only for 1 age type.
What is the best approach to achieve this? As I started working on the database query it became quite tedious I was selecting each combination to calculate the result.