Advanced Summaries in Query Studio |
You can use the advanced summaries feature to apply one summary calculation to the detail values and a different summary calculation to the footer values.
In most calculations, the default order of operations for detail values is summarize first, then calculate.
However, if a calculation involves two or more columns that have different detail summaries applied, the default order of operations is calculate first, then summarize. For example, you create the calculated column SALES using the formula PRICE (averaged) * QUANTITY (totaled).
For footer values, the default order of operations for most calculations is also summarize first, then calculate. However, there are two exceptions when the default order of operations is calculate first, then summarize. The first exception is when a calculation involves two or more columns that have different detail summaries applied. The default is calculate first, then summarize. For example, you create the calculated column SALES using the formula PRICE (averaged) * QUANTITY (totaled). The second exception is when a calculation involves a single column that is totaled, and a constant is added to this column. For example, you create the calculated column SALES + 1.00.
To add an advanced summary to a Query Studio report:
Tip: To remove a summary, in the Summary for footers box, click None.
Related Topics: