Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by MajikTwo

  1. MajikTwo

    Help Needed / Appreciated...

    Hi TheBugSlayer Thanks for your input, but usually it takes more then 2 items to fill up 60% ratio, actually it's unkwohn how much, so the Top 2 for sure no. Anyway thank you all, I rearanged my Report and pass it thru VB and fill up my report from, instead of using only SQL, Thanks r937...
  2. MajikTwo

    Help Needed / Appreciated...

    Sorry I'm not seeing it with NTile, from what I understood it will divide my rows into sections/Buckets. But my problem stay the same, I need to know when to stop when my Pourcentage is 60 or more, and here is the ratios Item...... TotSales..... ItemQty...... TotQty.... RatioQty.... RatioValue...
  3. MajikTwo

    Help Needed / Appreciated...

    When I'm searching for the Top Quantity Seller, It should return Item 1 and 2, by this order. When I'm searching for the top Value Seller, It should return item 3 and 2, by this order also. The logic is to have the top of the cream from higher to lower, in a pourcentage of top 60%.
  4. MajikTwo

    Help Needed / Appreciated...

    Hi again What I need is to choose the best selling items (By QTY) in my list, they should be in the Top 60% of my total sales Quantity, In this case it returns Item 1 and 2, 39 et 30. In case I want the best Top 60% of my total Sales (Value), the answer will be Item 3 and 2, 30790.00 and 28540.00
  5. MajikTwo

    Help Needed / Appreciated...

    Hi gmmastros Thanks for your reply, but it's NO GOOD. Having Sum(Qy) > = 60 will return nothing, it search in the Sum of each item for one >=60 It don't make a sum of the sum and return item 1 and 2. Sorry no cigar yet.
  6. MajikTwo

    Help Needed / Appreciated...

    Hi I have this query : Select Inv.ItemId As Item, Sum(Inv.RowTotal) As TotSales, Sum(Qty) as ItemQty, (Select Sum(Qty) From Invoice) As TotQty from Invoice Inv Group by Inv.ItemId It returns : Item...... TotSales..... ItemQty...... TotQty 000001... 18510.00..... 39.00......... 90.00...
See more

Part and Inventory Search

Back
Top