Hi there,
I have an existing Klip Table ("Table 1") with data from a single source ("Source 1") aligned as follows:
- Model Name
- SKU
- Launch Date
- In Transit -- this is the column I'm trying to populate with data from Table 2
Table 1
I'm trying to set up a second Klip Table ("Table 2") (that will be hidden) which sums up the quantity in transit for a particular SKU from a different data source ("Source 2"). The idea is to just do a LOOKUP using the SKU column in Table 1 to get the total quantity In Transit for that SKU based on the aggregated data in Table 2.
Table 2
Essentially, I'm trying to get the total sum of Items - Quantity Expected (Column I) for each unique SKU in Column C (which would then tie into the "SKU" in Table 1). I've tried various combinations of SUMIF, SUM(IF), SUM(GROUP), etc., but can't seem to get the formula right.
If I was using Excel, I'd just do a SUMIF formula with my criteria as Column C and sum range as Column I, but I can't get that to translate to Klipfolio.
To summarize, I need help:
- Totaling the sum of Items - Quantity Expected in Table 2 by the grouped SKU; then
- Looking up the sum from Table 2 and pulling that value in to Table 1 using the SKU in that table.
Appreciate any help!
