Working with Pivot Facts

Core numeric data that you slice and dice dimensionally in your analysis are called facts. Facts can be summed to create totals.

You can calculate totals for both columns and rows in a Pivot report. If you layered dimension items along the top or side labels of your report, you can calculate the totals for any level in the hierarchy. When you select an inner dimension for totaling, subtotals are created for each of the categories in the outer dimensions. Totals in the Pivot section include: