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.