Implementing an aggregated calculation that must respect a specific dimension's granularity, such as computing the average of a per-customer sales sum.