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)
User | Count |
---|---|
22 | |
15 | |
4 | |
3 | |
3 |