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



  • GrantSmith
    GrantSmith Indiana 🥷
    edited September 28

    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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🔴

    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"