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