SYMPTOM
When adding attributes from multiple datasets into a document template, the total of a derived metric displays as '--' after doing custom sort on attribute.
REPRODUCE STEPS
1.In Strategy Tutorial project , add two datasets with several attributes and metrics into a document.
2. Add attributes from both two of datasets into template. Insert a new metric from dataset object panel directly and add into template, like Count(Category) below. Edit grand total and subtotals across each level.
3. Select custom sort by right clicking attribute header in template. Just modify an element order or any other customization sort.
5. Two dashes '--' display in metric total after doing custom sort.
CAUSE
Customization sorting change the calculation level of new inserted metric total. This is an issue when the distinct count interact with custom sort.
ACTION
This issue was reviewed by our Technology team for feasibility and will not be scoped for any upcoming Strategy release
Article reference number: KB441409
