How to use raw SQL (pass-through) functions to identify aggregations for an entire data set, regardless of the filters applied to the view.
When you apply a filter to a view, the field aggregations apply only to values that are within the bounds of that filter.
For example, suppose you have three Sales receipts ($10, $100, $150) and you filter your view to show only receipts over $20. The $10 value is not included in an aggregation of the Sales field of this view. SUM([Sales]) computes to $250, and MIN([Sales]) to $100.
You might want to filter the values that appear in the view, but include the outlying values in calculations. In the example above, you might want to know the percentage of total sales for each transaction, with total sales including all sales in your original data set, not just limited to those within the filter.