I have a base I’m using to formulate beauty products. Each ingredient in the product is in a row on the table and the resulting amounts need to be converted from weight to percentages. I’ve done so by creating a sum rollup in the parent relationship (not sure if that’s a term or not) and using the total to create the formula in the table. So far so good. It turns out there are at least two different subsets of products, each needing their own percentages in the same column of the same table. Is there a way to roll up these two different subsets in order to get separate percentages in the same column? I’ve tried creating a subcategory table to represent the two different subsets of products but now I’m stuck. It’s basically a rollup through two variables. Is it possible?
