How to find the top 20 most order items in reports

[Chandu Telu]

HI Team,

I Need to create a report on that reports i need to show top 20 most order items in reports

Can some one help me on this

Thanks

Chandu Telu

[gauravchoudhury · Accepted solution]

Hi Chandu,

I created some dummy records to help you show a dummy report with you required request. As you can see it has shown me a list of all available items in a bar chart.

Please refer to the screenshot below:

If you are looking to have only top 20 then in that case, simple export the require report to excel and then use a pivot table to sort & filter your required data. After which you can use Bar chart or any form of chart in Excel itself.

The process could be a tad bit longer but certainly assures the end result without scripts.

[gauravchoudhury]

If your query has been answered, please mark my response as 'Correct'.

[Goran WitchDoc]

You know there already is OOB reports and so for this. It exists at least in Istanbul, not sure exact which release came with. But you also have a module called "Request reports". It's should be under "Service Catalog->Catalog administration->Request reports". There is a OOB report called "[Catalog] Most Commonly Requested Items".

//Göran

[Charlie Ward]

Thanks Goran. This was helpful to me. I needed this for a different table and I was able to use the parameters to get the data I needed. This answer should be the "Correct Answer" instead of exporting data to excel like what is tagged as the correct answer.