Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm facing an issue where in to get sum of top n values. I'm able to restrict the values while showing but coming to summing the top n values, Sum is calculated to all the values. Request you to give me an idea how to achieve it.
Will you able to provide sample application
find the attachment,
In this if u see for sub Category wise i need top 3 and sum of that 3(66+45+65) in ABC Category,
here it is taking total sum instead of 3.
with
aggr(if(rank(sum(Qty))<=5,Sub Category)
,Category,Sub Category) expression i am getting the results,
but for some categories it is showing 2 sub categories even values are not same.
There is no sheets in the attached file... have you attached the right file?