lookup and reference aggregation values