Summarise info from one table in another

Topic Labels: Formulas
632 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi! I have 2 tables - one with a long list of individual clients, and another listing “teams”, which the clients belong to.

The client table has 2 fields: “Team” & “meal preference”.

I want to summarise the meal preference data in the Team table table, organised to show the total number of each meal preference for each team.

I have set up a pivot table block, which does summarise this, but I don’t know how I can pul this info into the “Team” table.

Any assistance greatly appreciated!

1 Reply 1

For each meal preference, create a Count field in the Team table which only counts the linked clients if preference = x