Skip to main content
Announcements
Happy New Year! Cheers to another year of collaboration, connections and success.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to get TOP 3 and Bottom 3 AVG and Max Difference value with rank function and AGGR.

We are having the requirement of top 3 and Bottom 3 avg of value.

Max of difference of Avg of top 3 and bottom 3.

11 Replies
lironbaram
Partner - Master III
Partner - Master III

hi

look at this file

QS21
Creator
Creator

Hi I am unable to view this solution (QVW), could u post  the logic in comments pls?