Using Avg in a Pivot Table

[#1]

I am trying to get the average age of drivers by policy number.  Using Avg([Driver Age]) gets me the same average for each policy.  Using the aggr function,

Aggr(Avg([Driver Age]), [Policy Number]), gets the same result.  Adding Total to the expression returns null.

[Anonymous]

How about AGGR(AVG(SUM([Driver Age])),[Policy Number])

[#3 · Accepted solution]

How about sum(driver age)/count(distinct policy number)

[qliksus]

Where you are adding the total  are you giving

like  this  Aggr(total  Avg([Driver Age]), [Policy Number]))  or

Aggr(Avg(total  [Driver Age]), [Policy Number]))  this should not give you null