Skip to main content
Question

How to get top 20 Item in Pivot Table


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
Captain II
Forum|alt.badge.img+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

 


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

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings