I am attempting to obtain a list of the top 10 items for the current year, based on their order quantity. I have tried using the "select top" option in the generic inquiry, but it is not providing the desired results. What I require is the total quantity summed up, and then the top 10 items should be displayed in a pivot table.
How to get top 20 Item in Pivot Table
Hi
Here with attached the GI - xml
Hi
By using Pivot table has to find the top 20 Items Sold to customers
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/f05a34b4-d180-4d01-b998-641c4c422df0.png)
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.