Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Resolved...
=Avg(aggr(sum(QuantitySold), [SalesDate.autoCalendar.YearMonth]))
Resolved...
=Avg(aggr(sum(QuantitySold), [SalesDate.autoCalendar.YearMonth]))