Top 3 and Bottom 3 Article and Qty

[Naresh Yadav]

Respected all,

I need a formula that can allow me to get the Top 3 and Bottom 3 article list along with their Qty on store+category level

Condition are as follow:-
pls do not consider Zero sale while getting Top3/Bottom3 article list
If the count of store+Cat combination is less than 3 than result should come upto max count only

regards
Naresh

 

[p45cal]

Do the tables in columns R and W of the attached give the correct answers?

 

[Naresh Yadav]

Dear Sir,

Sorry for Late Reply and thanks for effort and support
I have almost got the result except the Count of Top3 and Bottom 3 article is more than 3 times which needs to be removed

regards
Naresh

 

[p45cal]

I have almost got the result except the Count of Top3 and Bottom 3 article is more than 3 times which needs to be removed

I don't understand this sentence, but I'll have a go.
In some instances looking for the bottom 3 there are more than 3 results showing (eg. DL is showing 15). They're all showing an SLS Qty of 1. If you want only to see 3, how do I decide which 3?