How can we write set analysis expression for showing Avg(Population) for dates less than X.
For example, if I have population value at 3 different dates (W, X, Z), I would like to show Avg(Population) for all the dates less than X. Average value should not include population value at Z.