• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Top 3 and Bottom 3 Article and Qty

Naresh Yadav

Active Member
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
 

Attachments

Naresh Yadav

Active Member
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

Well-Known Member
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?
 
Top