How can I calculate volume of Top n brands in Table?

[#1]

Hi,

I struggle for the last 2 days with this problem but I can't figure it out. I want to have a table which gives out volumes by 2 Dimensions (Number and NewKey) and adds up the Top 4 by brand. I tried various combinations of rank and aggr function with sum without success. To show better what I want to achieve, please check out the picture...

[MK_QSL]

It would be better if you provide sample data or sample application along with the result in excel.

[swuehl · Accepted solution]

Maybe like

=Sum( Aggr( if( Rank(Sum(Value)) <=4, Sum(Value)), Number, NewKey, Brand))

[#4]

Thanks swuehl, you are spot on! I tried a lot of different nested functions, but not this combination.