Question

How to get top 20 Item in Pivot Table

  • 29 June 2023
  • 4 replies
  • 81 views
S
Rank

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

Kandy Beatty
Rank
Userlevel 7
Badge +16

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*.
S
Rank

Hi @kandybeatty49 
Here with attached the GI - xml
 

1 Attachment
S
Rank

Hi @kandybeatty49  

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

 

Chris Hackett
Rank
Userlevel 7
Badge

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*.

Reply


Terms & ConditionsCookie settings
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