I have a table that has products and the number of orders in liters. I have another table that the product name with the conversion between liters and cases. The problem is that one product can have the same number of liters but different number of cases. So the cases is really dependent on which product it is.
Table 1: Order by volume
Product, Orders
A, 10 L
B, 20 L
C, 40 L
D, 80 L
Table 2: Conversion table
Product, Liters, Cases
A, 10 L, 2 Cases
B, 10 L, 3 Cases
C, 10 L, 1 Cases
D, 10 L, 6 cases
I need the ability to be able to toggle between liters and cases. What can I do?
.png "Former Employee"){kind=icon}