Skip to main content

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.

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

 


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


Reply