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

gbrown · 2022-09-28T16:42:51+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

SQL

Cards

Beast Mode

Accepted answers

All comments

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.

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of