Analytics Software

Hi,

I have a fact table with a population measure,I need to set the aggregation for the population to average for the time dimension and sum for others. (the report required to measure the population during a period of time in two different years).

when i am trying to do this using the based on dimension check box in the aggregation tab the measure values does not shown in the answers.

if i set the aggregation to sum and uncheck the based on dimension i receive results but not the one i am looking for.


Thanks in advance.