1 of 1 people found this helpful
if this is how your data are structured you have 2 dimensions Type and No - use Rank_unique(sum(Quantity),'desc') and then filter for <=3 on the rank -
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks for the response. The solution is very near to the requirement. The solution will giving me two outputs
1. Max Qty of that No
2. Count of Max Qty of that No
The requirement is to have Top 10 (sum of Qty) for No group by Type.
not able to attached project. please share your mail id, will mail you
sorry that's not what your post said - this is a different question
please post separately
No Worries.. I have created new Post