Unexpected Summary Values in Nested Sets
If a report contains nested sets, summaries
other than the inner set summaries may contain unexpected values.
For example, you insert a summary in a crosstab that contains a set
with years in the rows.
Figure 1. Example of revenue numbers for the years
2012 and 2013
You then nest a product line set within years.
Figure 2. Example of revenue numbers for the listed
products for the years 2012 and 2013
Notice that the summary value does not change to represent the total of the new values. This occurs because the within set aggregation used with dimensional packages does not take into account sets that are nested below the set that is summarized.
To show the correct summary values, if the inner and outer sets do not belong to the same dimension, you can nest a copy of the inner summary item under the outer summary item, as follows.
Figure 3. Example of the combined aggregate set
for the years 2012 and 2013