Hi,
I have transactional data over periods of time. Data includes dates and time periods as well as SKUs and Net sales. I want to be able to dynamically rank SKUs based on net sales to create a top 10 group and then compare that group to the total sales for the category.
Trying this but I don't want the SKUs in my report
CASE WHEN RANK() OVER (PARTITION BY SKU USE ME
ORDER BY SUM(Net Sales
) DESC) <= 10 THEN 'Top 10'
ELSE 'Balance'
END
I want to create a group of top 10 and not top 10 and then compare to total for that week but be able to filter for the year and have it adjust.