I have a table of Recipe Ingredients with columns (Recipe, Ingredient, Amount). I want to create a Shopping List table so that when a User picks out Recipes, it aggregates and sums the Amount by Ingredient. For example: [image]

Hey @Jennifer_Lastimosa , here is an example how to do that: The main formula in the ‘total column’ is: =Recipes.Filter(Ingredients=thisRow.Name).Amount.sum() This will search your Recipe table by all occurings of the Ingredient in the current row gets the amount of it sums all the amounts An…

Aggregate Table

Jennifer_Lastimosa August 14, 2019, 1:06am 3

Sorry for the late response, but thank you so much for this!

1 Like

Topic		Replies	Views
Sum only parts of a table	5	2584	January 8, 2019
How to create a new row with aggregated values?	6	746	April 4, 2020
Table with single select of subtables to pull the sum	9	3066	July 1, 2019
Sum of one Column into a table cell of another?	4	904	November 8, 2018
Itemise every combination of a select list	6	487	May 16, 2022

Aggregate Table

Related topics