Skip to main content
Question

How to get top 20 Item in Pivot Table

  • Jun 29, 2023 10:08 AM UTC
  • 4 replies
  • 179 views
  • Translate All

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+18

HI @seenivasank57 

Can you share your pivot table and GI?

Translate

  • Author
  • Freshman I
  • Jun 30, 2023 10:34 AM UTC

Hi @kandybeatty49 
Here with attached the GI - xml
 

Translate

  • Author
  • Freshman I
  • Jun 30, 2023 3:05 PM UTC

Hi @kandybeatty49  

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

 

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • Jul 13, 2023 9:57 PM UTC

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

Translate