Report which selects top N records of each group from entity

(0) Share

Report

Posted on by Drashti Mehta

260

Hi Experts,

I am new to CRM reports, i want to generate a report which contains top N records of sum of amount in entity say A of each territory in the same entity. This means i want top N records of every territory with sum of amount. Can anyone suggest me how can i get this. I tried with the report wizard of CRM but was unable to get top N records. I also tried with SSRS reports where i could only get total N records irrespective of territories. Please suggest ASAP.

Thanks

Drashti Mehta

*This post is locked for comments