Hi,
i have task to get top 20 percent bestselling item from Transaction Sale Entry table
right now what i'm doing is copy all data to excel and analyze from that
but could there be a better way such as sql query to pull top 20 percent data from database
Thank you
*This post is locked for comments
it worked, thank you for solution
i don't have to use pivot table to sum total sales by item anymore
Depends on how you build the report - top in sales volumes or in sales quantities. Please check there are standard reports, e.g. "Inventory - Top 10 List Report" msdn.microsoft.com/.../hh172131(v=nav.90).aspx . How do you calculate now in Excel?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (