SYMPTOM:
When selecting ‘Total’ in the Page-by field, the ranking metric shows wrong results in Strategy Developer 9.4.1 - 10.x
STEPS TO REPRODUCE:
Follow the steps below to reproduce this issue with Strategy Tutorial project:
1. Create a Ranking metric with Revenue.
2. Create a report with the attribute Subcategory in the row, the metric Revenue and ranking Revenue in the column. Add the attribute Year to the Page-by field. Run the report as shown below:
3. Enable the ‘total’ Subtotal for the report.
4. Run the report, note that the ranking metric displays wrong result, as shown below:
CAUSE:
‘Allow Smart Metric’ option is not enabled in this metric and the ranking metric is aggregated.
ACTION:
Enable the ‘Allow Smart Metric’ option under Subtotals/Aggregation Tab in the metric editor. The result is as shown below:
