Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculating Total Distributions

I have two tables—one for Sales and another that lists Donations. I'm trying to "unpack" the bundles from Sales and Donations so that I can calculate the total distributed units for each product. 

 

Bundle 1 includes Textbook A and Textbook B. 

Bundle 2 includes all three textbooks—Textbook A, Textbook B, Textbook C.

 

Here are my tables:

And here is what I want to produce: