The way the data is currently structured will not allow for this type of breakdown. Instead of having a different field for each Part, they should all be in a dimension together. The following KB provides further information on how to structure your data:
You may be able to easily rearrange the data using the Reshaping Tool:
I installed and reshaped data, built a parameter with four values (Flow Rate, BTU, Total QXJT, Total Parts), and a calculated field to refer to those four.
I'm having difficulty getting the filter to work with the newly reshaped data.
I've attached a workbook. Am I going in the right direction? What am I missing?
LCL_Tool_101.twbx.zip 34.3 KB