Dear Alexis - As per my understanding, the given dataset is like a dimensions that you want to apply to your transactions. Let me explain. This is similar like the following
PRODUCT GROUP STATE TAX%
TABLES CA 5%
CHAIRS CA 6%
PHONES NY 9%
TAX % is a function of Product Group and STATE Combination
I would recommend, don't write case statement , nested if , nested LODs, everything will be static in nature. Instead have the data and loaded into an Excel or a Table. Then bring that table / Excel to Tableau and blend this with your actual Transaction dataset. Blend key should be PRODUCT GROUP and STATE together.
This will give you more flexibility to dynamically update or modify the base logic.
In my table, Yield is not a calculated function of the other 2, I just want to call the value of Yield based on the values of product group and component for the purposes of a further calculation.
Thanks... great to learn new things