Skip to Content
0
Former Member
Apr 22, 2010 at 04:12 AM

Mechanism to count the top % of material

26 Views

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