Hi
There is a requirements to show the material no, sales qty and stock-on-hand qty. Before query broadcast to user thru email, the format of the query should sort by sales qty in descending follow by filter the top xx % based on material no. The material no will take in as count only either sales qty or stock-on-hand qty not 0.
May I know how can I achieve the above in the query designer?
Regards
Kang Ring