Create monthly totals from table with daily data

[mallika]

Summary/Aggregate Views

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. Base Table- [19%20AM] Using Grouping to create the summary/aggregate view (Filtered with a control so it is easy to change the view based on date ranges - [57%20AM] Using a filter formula in a new table. This is useful when you want data from multiple table or wa…