Lookups with multiple key columns

Calculations in Sigma

Mandy Gray

Solutions and Enablement Lead at Aimpoint Digital

Lookup behavior with multiple matches

$$

multiple valies

$$

  • multiple values appears when single record receives more than one match
Calculations in Sigma

aggregating

Calculations in Sigma

Carefully consider key columns

multiple key columns

Calculations in Sigma
Calculations in Sigma

Let's practice!

Calculations in Sigma

Preparing Video For Download...