Need a way to roll up data

[SharonCNE]

Team:  I need a way to track when a craft kit has been purchased.  For example if someone was buying parts towards a complete kit I would like to be able to have one line item once all the parts are purchased "complete kit".  An example of the data would be like below. There is no specific order to buy the parts so I can't even say once (this piece) is purchased it's comple. There could be multiple people buying multiple craft items

Craft	Part	Date Purchased	Customer
Doll	Head	11/5/2020	A
Doll	Body	12/19/2020	A
Doll	Legs	1/15/2021	A
Doll	Arms	3/5/2021	A
Car	Car Body	12/5/2020	B
Car	Wheels	2/10/2021	B
Car	Doors	4/1/2021	B

[DataInsights]

@SharonCNE,

It sounds as if you need a master table that contains all parts for each kit. For example, the Doll kit would have four rows in this master table:

Then you could compare, by Customer, the number of distinct parts in the data table to the number of parts in the master table (for that Craft). If the number of parts matches between the tables, then a complete kit has been purchased.