We are building a dashboard and one of the objects contains 100,000+ records. Let's say, each month contains 10,000+ records (imagine them as sales and return transactions).
We would like to present a summary table that shows each month's summary with a number of fields, say total sales and total return of a month.
We found that this summary table cannot be generated by using pivot table (it contains many restrictions). By using a table view and table grouping, the grouping summary is there but there is no way to hide the detail rows.
Is there any way to generate a summary table ?