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
Badge +16

HI @seenivasank57 

Can you share your pivot table and GI?

Hi @kandybeatty49 
Here with attached the GI - xml

Hi @kandybeatty49  

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


Userlevel 7

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


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