In the Results and reporting sections, Interactive Reporting performs computations on the desktop. The computations involve only the data in your Results set or on the surface of a reporting section.
In these sections you can only create new computed items: you cannot modify original data items retrieved directly from the database. For the same reason, scalar functions used to compute items in these sections are provided by the Interactive Reporting, rather than the RDBMS.
Computed items in the Results and reporting sections differ in two respects:
In the Results and Table sections, reference items are filtered to the items that are displayed on the Request line.
In the remaining reporting sections (excluding the Report Designer section), reference items are limited to the items placed in the Fact pane in the data layout. Computations in these sections work on the aggregated cell values that make up the core of the report. To perform computations on data before it is aggregated, compute the new item in Results.
In the Report section, the break totals of a table can be calculated