3 Replies Latest reply: Jan 11, 2012 4:28 AM by susant Kumar swain RSS

    Using Avg in a Pivot Table

    Stuart Wenzel

      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.