Top 10 & Top 20 Mean

[chaitanyajami]

Hi,

I am showing below data in straight table ,but stuck with how to show mean for top 10 and top 20 records, can someone please suggest how to achieve it.

[Anil_Babu_Samineni]

Top 10 and 20? They are two reports? You want to show in single report? Will you explain little more and please provide Mock up Application

[settu_periasamy]

Not sure. May be try like

=Avg(aggr(if(Rank(total CurretColumExpression)<=10, CurretColumExpression), YourDimension))