Skip to main content
Question

How to get top 20 Item in Pivot Table

  • June 29, 2023
  • 4 replies
  • 128 views
S
Freshman I

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.

Kandy Beatty

4 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Kandy Beatty
  • Captain II
  • June 29, 2023

HI @seenivasank57 

Can you share your pivot table and GI?

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
M
S
Freshman I
  • seenivasank57
  • Author
  • Freshman I
  • June 30, 2023

Hi @kandybeatty49 
Here with attached the GI - xml
 

1 Attachments
S
Freshman I
  • seenivasank57
  • Author
  • Freshman I
  • June 30, 2023

Hi @kandybeatty49  

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

 

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • July 13, 2023

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
Terms & ConditionsCookie settingsAccessibility statement
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