Report Builder - Top n Number of Records from Each Group and the most recent record

Related products: None

Hello Team,

 

Lets think of a scenario in which I would like to see the top 10 records from each grouping.

 

For Example, As a Company X we provide Product A, Product B and Product C. Now I would like to build a report to show the Top 10 customers who purchased Product A, Top 10 customers who purchased Product B and Top 10 customers who purchased Product C. I know all these are achievable by creating individual reports. But I would like to build one single report and it should show all these records under different grouping.

 

Lets make it more complex.

 

As a Company X we provide Product A, Product B and Product C. Now I would like to build a report to show the below grouping.

 

Top 10 customers who purchased Product A and most recent sentiment.

Top 10 customers who purchased Product B and most recent sentiment.

Top 10 customers who purchased Product C and most recent sentiment.

 

Currently there is no way in report builder to fetch only the most recent record of a Company or Relationship or any specific object.

 

Lets make it even more complex:

 

As a Company X we provide Product A, Product B and Product C. Now I would like to build a report to show the below grouping.

 

Top 10 Percentage customers who purchased Product A and most recent sentiment.

Top 10 Percentage customers who purchased Product B and most recent sentiment.

Top 10 Percentage customers who purchased Product C and most recent sentiment.

Be the first to reply!