Report showing users who ahve ordered more than once of the same catalog item

[Alex Saager1]

Hi Community,

I'm trying to run a report that shows users who have ordered more than one of the same catalog item but it doesnt seem to be giving me the required results.

Here is the report im trying to run but cannot seem to get the (count > 1 to work) what am I missing here:

[kaushal_snow]

@Alex Saager1 ,

To report on users who have ordered the same catalog item more than once, create a report on the sc_req_item table (or another relevant table if you have extended/modified) and in the report definition set Grouping for two fields: Requested by (user) and Catalog item, then use the Aggregation function (for instance Count  Number of records) and apply a filter or having style condition to show groups where that count is greater than 1; if the UI doesn’t allow a direct HAVING count > 1 clause you may need to add a custom field via a business rule or scheduled job that flags duplicate orders and then filter on that flag.....

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.