Trying to Find the Top 10 part numbers by $'s for the year for each plant department.

I have a large table showing plant department and their part numbers with the quantity scraped / dollar amount scraped as the values. Is there a way to only show the top 10 part numbers by department in dollars? Trying to be able to always keep track of what top part numbers are being scraped. Thanks


Tagged:

Answers

  • GrantSmith
    GrantSmith Coach
    edited September 2022

    Try creating a beast mode with a window function and then filter the value to be 10 or less

    This will calculate the row number base on the highest amount total being first for each department

    SUM(SUM(1)) OVER (PARTITION BY `Plant Department` ORDER BY `AMOUNT TOTAL` DESC)
    
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • rank() OVER (PARTITION BY `Plant Department` ORDER BY sum( `AMOUNT TOTAL` ) DESC )

    if you don't order by sum of amount total, you'll only have the largest sale event.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"