Hello.
I am trying to pull the top 3 products (highest $ Ending Inventory value) for each of our stores.
I am working with table "Weekly Ending Inventory"
Field's I am using are 'Short Name', 'Product_Name', and 'Total Ending Inventory'
Here is what I would like my results to look like
Short Name Product Name Total Ending Inventory
Boston Chicken Strips $350
Boston Charp Cheddar $105
Boston Lettuce $20
Los Angeles Beef Patty $425
Los Angeles Chicken Breast $408
Los Angeles French Fries $355
I have looked at similar post, but have been unsuccessful.
Please help.
I am trying to pull the top 3 products (highest $ Ending Inventory value) for each of our stores.
I am working with table "Weekly Ending Inventory"
Field's I am using are 'Short Name', 'Product_Name', and 'Total Ending Inventory'
Here is what I would like my results to look like
Short Name Product Name Total Ending Inventory
Boston Chicken Strips $350
Boston Charp Cheddar $105
Boston Lettuce $20
Los Angeles Beef Patty $425
Los Angeles Chicken Breast $408
Los Angeles French Fries $355
I have looked at similar post, but have been unsuccessful.
Please help.