Fact detail cells are derived from the data set that you retrieve from your database and can be analyzed in both the Results and Pivot section. The Results section is a flat representation of raw, un-aggregated data from a database or external data source as shown below. This example shows sample Sales data for several cities in the USA.
A Pivot section is a flexible tabular display of aggregated data in Interactive Reporting that receives its source of data from either a Results or Table section. As an example, the same Table section City/Units Sold data from above can be converted to a simple Pivot section as shown below.
In the Pivot section, the Units Sold data has been aggregated; that is, there is only one occurrence of each City name shown in the Pivot section Row Labels. The Units Sold data for each City has been summed from the entries in the Table section above to show a single value for each City - these are the Pivot section Detail Facts.
