Some users may have the requirement of using calculated fields for their metrics, since calculated fields would be computed by Excel for each item in the PivotTable, rather than simply summed.
NOTE:
PivotTables are a Microsoft component. Subtotals are calculated by Excel and this is a known limitation of PivotTables. This issue is not specific to Strategy.
Example:
Consider the example below where the totals are calculated by summing each individual field:
Below are instructions on how to insert a Calculated Field:
