SYMPTOM:
After creating a simple report which displays subtotals in both the columns and rows, users notice that where the subtotals intersect, no data is displayed:
However, both substotals are used for the same calculation. In this example, Total calculates the sum of all metrics across columns, and the "Pretty Name" subtotal calculates the sum of all metrics across rows. If the user uses one subtotal object only, instead of two, the values in the intersection are correctly calculated:
However, the user wishes to use two different subtotal objects that perform the same calculation so that the name of the subtotal that calculates the sum of all metrics across the rows is different to the name of the subtotal that calculates the sum of all metrics across columns.
CAUSE:
This is working as designed. The intersection of two different subtotals is not calculated and therefore does not display any value.
