compare the sum of two virtual columns

I need to compare the sum of two virtual columns with the same parameters from two different tables.
Example of tables:
- Table with virtual column SKU. I have the sum of all products with the same SKU, e.g.:
100 products with SKU1 and 200 products with SKU2
- A table with added SKUs (purchased products). For example, I have purchased 99 products with SKU1 and 198 products with SKU2
I need to create a view in Appsheet that will compare these 2 tables and give me the result:
SKU1 = 1 item
SKU2 = 2 items

Translated with www.DeepL.com/Translator (free version)

0 4 196
4 REPLIES 4
Top Labels in this Space