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

gbrown

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

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)

jaeW_at_Onyx

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.