How to get top 20 Item in Pivot Table

  • 29 June 2023
  • 4 replies

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.

4 replies

Userlevel 7

Hi @seenivasank57 were you able to find a solution? Thank you!

Hi @kandybeatty49  

By using Pivot table has to find the top 20 Items Sold to customers


Hi @kandybeatty49 
Here with attached the GI - xml

Userlevel 7
Badge +16

HI @seenivasank57 

Can you share your pivot table and GI?


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved