Avg Aggr issue

[jerryr125]

Hi - 

I am trying to create a KPI showing the average of the quantity sold / product name based upon the selection.

=Avg(aggr(sum(QuantitySold), [ProductName]))

Example - the three values are 483,404,1152.

The total is 2039 and average is 679.

It is displaying 2039 instead of 679 - thoughts ? 

[jerryr125 · Accepted solution]

Resolved...

=Avg(aggr(sum(QuantitySold), [SalesDate.autoCalendar.YearMonth]))