Objective/usefulness: Create on-the-fly calculations with the existing Report data. Proceed as follows:
- Close the Report resulting from the preceding drill operation and return to the parent Report.
- Right click on the Revenue header | Insert | Percent to Total | Grand Total, as shown in the next screenshot:
Creating on-the-fly calculations with the existing Report data
A derived Metric is a Metric local to the Report that won't cause a SQL but instead will be calculated in memory by the Intelligence Server.