We often get asked about creating an aggregate or summary table for a tables with multiple rows. These are two ways I like to do it. Would love to hear about other ways you do it or places where you have used something like this.
Using Grouping to create the summary/aggregate view (Filtered with a control so it is easy to change the view based on date ranges -
Using a filter formula in a new table. This is useful when you want data from multiple table or want to do further calculations without adding more to the base table.
Adding a sample doc -