Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Not sure. May be try like
=Avg(aggr(if(Rank(total CurretColumExpression)<=10, CurretColumExpression), YourDimension))