Friday, February 8, 2013

How to define custom subtotal displays based on attribute names?





To define a specific subtotal displays for a report, select Subtotals from the Data menu.Clear the Totals check box to remove the standard subtotals.Click Advanced, then New to create a custom subtotal.

Type the following for the name: "Total for the #P #0". Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute.








All the metrics on the report are listed. Users can select the subtotal function to use for each. Total is correct for all of the metrics.