EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  3. Topics

KB16927: How to define custom subtotal displays in MicroStrategy Developer 10.x

Stefan Zepeda

Salesforce Solutions Architect • Strategy

Custom subtotal walk through

By default, when users apply subtotals in a report, the name of the subtotal is displayed in the subtotal line items that appear in the report. Users can use custom subtotals to give more control over the characteristics of a subtotal. Custom subtotals allow users to define custom subtotal line items that appear on the reports.
 
Users can make the subtotal name dynamic by typing special characters in the subtotal name field as listed in the following table.
 
 

Custom group that displays Top 10 Customers and Bottom 5 Items
EM_ITEM_IDEM_ITEM_NAMEEM_ITEM_TABLE1USEREM_USER2PROJECTIS_PROJ3ATTRIBUTE FORMIS_ATT_FORM4TABLEIS_TABLE5TRANSFORMATIONIS_TRANS6HIERARCHYIS_HIER7COLUMNIS_COL8REPORTIS_REP9DOCUMENTIS_DOC10FILTERIS_FILT11TEMPLATEIS_TEMP12METRICIS_MET13CUSTOM GROUPIS_CUST_GP14CONSOLIDATIONIS_CONS15PROMPTIS_PROMPT16SERVER DEFINITIONIS_SERVER17EVENTIS_EVENT18SCHEDULEIS_SCHED19FACTIS_FACT20ATTRIBUTEIS_ATT21USER GROUPEM_USR_GP22DB INSTANCEIS_DB_INST23DB TABLEIS_DB_TAB24SECURITY FILTERIS_SEC_FILT25TRANSMITTERIS_TRANSMIT26DEVICEIS_DEVICE27DB INSTANCE1IS_DB_INST1101USER_ETLEM_USER102PROJECT_ETLIS_PROJ103ATTRIBUTE FORM_ETLIS_ATT_FORM104TABLE_ETLIS_TABLE105TRANSFORMATION_ETLIS_TRANS106HIERARCHY_ETLIS_HIER107COLUMN_ETLIS_COL108REPORT_ETLIS_REP109DOCUMENT_ETLIS_DOC110FILTER_ETLIS_FILT111TEMPLATE_ETLIS_TEMP112METRIC_ETLIS_MET113CUSTOM GROUP_ETLIS_CUST_GP114CONSOLIDATION_ETLIS_CONS115PROMPT_ETLIS_PROMPT116SERVER DEFINITION_ETLIS_SERVER117EVENT_ETLIS_EVENT118SCHEDULE_ETLIS_SCHED119FACT_ETLIS_FACT120ATTRIBUTE_ETLIS_ATT121USER GROUP_ETLEM_USR_GP122DB INSTANCE_ETLIS_DB_INST123DB TABLE_ETLIS_DB_TAB124SECURITY FILTER_ETLIS_SEC_FILT125TRANSMITTER_ETLIS_TRANSMIT126DEVICE_ETLIS_DEVICE127DB INSTANCE1_ETLIS_DB_INST1CharacterDescription#AThe name of the attribute under which the subtotal appears.#PThe name of the attribute to the left of, or above the attribute under which the subtotal appears.#0All the forms of the parent element.#1The first form of the parent element reading from left to right or from top to bottom.#2The second form of the parent element reading from left to right or from top to bottom.#3The third form of the parent element reading from left to right or from top to bottom.#4The fourth form of the parent element reading from left to right or from top to bottom.

Custom group that displays Top 10 Customers and Bottom 5 Items
EM_ITEM_IDEM_ITEM_NAMEEM_ITEM_TABLE1USEREM_USER2PROJECTIS_PROJ3ATTRIBUTE FORMIS_ATT_FORM4TABLEIS_TABLE5TRANSFORMATIONIS_TRANS6HIERARCHYIS_HIER7COLUMNIS_COL8REPORTIS_REP9DOCUMENTIS_DOC10FILTERIS_FILT11TEMPLATEIS_TEMP12METRICIS_MET13CUSTOM GROUPIS_CUST_GP14CONSOLIDATIONIS_CONS15PROMPTIS_PROMPT16SERVER DEFINITIONIS_SERVER17EVENTIS_EVENT18SCHEDULEIS_SCHED19FACTIS_FACT20ATTRIBUTEIS_ATT21USER GROUPEM_USR_GP22DB INSTANCEIS_DB_INST23DB TABLEIS_DB_TAB24SECURITY FILTERIS_SEC_FILT25TRANSMITTERIS_TRANSMIT26DEVICEIS_DEVICE27DB INSTANCE1IS_DB_INST1101USER_ETLEM_USER102PROJECT_ETLIS_PROJ103ATTRIBUTE FORM_ETLIS_ATT_FORM104TABLE_ETLIS_TABLE105TRANSFORMATION_ETLIS_TRANS106HIERARCHY_ETLIS_HIER107COLUMN_ETLIS_COL108REPORT_ETLIS_REP109DOCUMENT_ETLIS_DOC110FILTER_ETLIS_FILT111TEMPLATE_ETLIS_TEMP112METRIC_ETLIS_MET113CUSTOM GROUP_ETLIS_CUST_GP114CONSOLIDATION_ETLIS_CONS115PROMPT_ETLIS_PROMPT116SERVER DEFINITION_ETLIS_SERVER117EVENT_ETLIS_EVENT118SCHEDULE_ETLIS_SCHED119FACT_ETLIS_FACT120ATTRIBUTE_ETLIS_ATT121USER GROUP_ETLEM_USR_GP122DB INSTANCE_ETLIS_DB_INST123DB TABLE_ETLIS_DB_TAB124SECURITY FILTER_ETLIS_SEC_FILT125TRANSMITTER_ETLIS_TRANSMIT126DEVICE_ETLIS_DEVICE127DB INSTANCE1_ETLIS_DB_INST1CharacterDescription#AThe name of the attribute under which the subtotal appears.#PThe name of the attribute to the left of, or above the attribute under which the subtotal appears.#0All the forms of the parent element.#1The first form of the parent element reading from left to right or from top to bottom.#2The second form of the parent element reading from left to right or from top to bottom.#3The third form of the parent element reading from left to right or from top to bottom.#4The fourth form of the parent element reading from left to right or from top to bottom.

Custom group that displays Top 10 Customers and Bottom 5 Items
EM_ITEM_IDEM_ITEM_NAMEEM_ITEM_TABLE1USEREM_USER2PROJECTIS_PROJ3ATTRIBUTE FORMIS_ATT_FORM4TABLEIS_TABLE5TRANSFORMATIONIS_TRANS6HIERARCHYIS_HIER7COLUMNIS_COL8REPORTIS_REP9DOCUMENTIS_DOC10FILTERIS_FILT11TEMPLATEIS_TEMP12METRICIS_MET13CUSTOM GROUPIS_CUST_GP14CONSOLIDATIONIS_CONS15PROMPTIS_PROMPT16SERVER DEFINITIONIS_SERVER17EVENTIS_EVENT18SCHEDULEIS_SCHED19FACTIS_FACT20ATTRIBUTEIS_ATT21USER GROUPEM_USR_GP22DB INSTANCEIS_DB_INST23DB TABLEIS_DB_TAB24SECURITY FILTERIS_SEC_FILT25TRANSMITTERIS_TRANSMIT26DEVICEIS_DEVICE27DB INSTANCE1IS_DB_INST1101USER_ETLEM_USER102PROJECT_ETLIS_PROJ103ATTRIBUTE FORM_ETLIS_ATT_FORM104TABLE_ETLIS_TABLE105TRANSFORMATION_ETLIS_TRANS106HIERARCHY_ETLIS_HIER107COLUMN_ETLIS_COL108REPORT_ETLIS_REP109DOCUMENT_ETLIS_DOC110FILTER_ETLIS_FILT111TEMPLATE_ETLIS_TEMP112METRIC_ETLIS_MET113CUSTOM GROUP_ETLIS_CUST_GP114CONSOLIDATION_ETLIS_CONS115PROMPT_ETLIS_PROMPT116SERVER DEFINITION_ETLIS_SERVER117EVENT_ETLIS_EVENT118SCHEDULE_ETLIS_SCHED119FACT_ETLIS_FACT120ATTRIBUTE_ETLIS_ATT121USER GROUP_ETLEM_USR_GP122DB INSTANCE_ETLIS_DB_INST123DB TABLE_ETLIS_DB_TAB124SECURITY FILTER_ETLIS_SEC_FILT125TRANSMITTER_ETLIS_TRANSMIT126DEVICE_ETLIS_DEVICE127DB INSTANCE1_ETLIS_DB_INST1CharacterDescription#AThe name of the attribute under which the subtotal appears.#PThe name of the attribute to the left of, or above the attribute under which the subtotal appears.#0All the forms of the parent element.#1The first form of the parent element reading from left to right or from top to bottom.#2The second form of the parent element reading from left to right or from top to bottom.#3The third form of the parent element reading from left to right or from top to bottom.#4The fourth form of the parent element reading from left to right or from top to bottom.

Custom group that displays Top 10 Customers and Bottom 5 Items
EM_ITEM_IDEM_ITEM_NAMEEM_ITEM_TABLE1USEREM_USER2PROJECTIS_PROJ3ATTRIBUTE FORMIS_ATT_FORM4TABLEIS_TABLE5TRANSFORMATIONIS_TRANS6HIERARCHYIS_HIER7COLUMNIS_COL8REPORTIS_REP9DOCUMENTIS_DOC10FILTERIS_FILT11TEMPLATEIS_TEMP12METRICIS_MET13CUSTOM GROUPIS_CUST_GP14CONSOLIDATIONIS_CONS15PROMPTIS_PROMPT16SERVER DEFINITIONIS_SERVER17EVENTIS_EVENT18SCHEDULEIS_SCHED19FACTIS_FACT20ATTRIBUTEIS_ATT21USER GROUPEM_USR_GP22DB INSTANCEIS_DB_INST23DB TABLEIS_DB_TAB24SECURITY FILTERIS_SEC_FILT25TRANSMITTERIS_TRANSMIT26DEVICEIS_DEVICE27DB INSTANCE1IS_DB_INST1101USER_ETLEM_USER102PROJECT_ETLIS_PROJ103ATTRIBUTE FORM_ETLIS_ATT_FORM104TABLE_ETLIS_TABLE105TRANSFORMATION_ETLIS_TRANS106HIERARCHY_ETLIS_HIER107COLUMN_ETLIS_COL108REPORT_ETLIS_REP109DOCUMENT_ETLIS_DOC110FILTER_ETLIS_FILT111TEMPLATE_ETLIS_TEMP112METRIC_ETLIS_MET113CUSTOM GROUP_ETLIS_CUST_GP114CONSOLIDATION_ETLIS_CONS115PROMPT_ETLIS_PROMPT116SERVER DEFINITION_ETLIS_SERVER117EVENT_ETLIS_EVENT118SCHEDULE_ETLIS_SCHED119FACT_ETLIS_FACT120ATTRIBUTE_ETLIS_ATT121USER GROUP_ETLEM_USR_GP122DB INSTANCE_ETLIS_DB_INST123DB TABLE_ETLIS_DB_TAB124SECURITY FILTER_ETLIS_SEC_FILT125TRANSMITTER_ETLIS_TRANSMIT126DEVICE_ETLIS_DEVICE127DB INSTANCE1_ETLIS_DB_INST1CharacterDescription#AThe name of the attribute under which the subtotal appears.#PThe name of the attribute to the left of, or above the attribute under which the subtotal appears.#0All the forms of the parent element.#1The first form of the parent element reading from left to right or from top to bottom.#2The second form of the parent element reading from left to right or from top to bottom.#3The third form of the parent element reading from left to right or from top to bottom.#4The fourth form of the parent element reading from left to right or from top to bottom.

Custom group that displays Top 10 Customers and Bottom 5 Items
EM_ITEM_IDEM_ITEM_NAMEEM_ITEM_TABLE1USEREM_USER2PROJECTIS_PROJ3ATTRIBUTE FORMIS_ATT_FORM4TABLEIS_TABLE5TRANSFORMATIONIS_TRANS6HIERARCHYIS_HIER7COLUMNIS_COL8REPORTIS_REP9DOCUMENTIS_DOC10FILTERIS_FILT11TEMPLATEIS_TEMP12METRICIS_MET13CUSTOM GROUPIS_CUST_GP14CONSOLIDATIONIS_CONS15PROMPTIS_PROMPT16SERVER DEFINITIONIS_SERVER17EVENTIS_EVENT18SCHEDULEIS_SCHED19FACTIS_FACT20ATTRIBUTEIS_ATT21USER GROUPEM_USR_GP22DB INSTANCEIS_DB_INST23DB TABLEIS_DB_TAB24SECURITY FILTERIS_SEC_FILT25TRANSMITTERIS_TRANSMIT26DEVICEIS_DEVICE27DB INSTANCE1IS_DB_INST1101USER_ETLEM_USER102PROJECT_ETLIS_PROJ103ATTRIBUTE FORM_ETLIS_ATT_FORM104TABLE_ETLIS_TABLE105TRANSFORMATION_ETLIS_TRANS106HIERARCHY_ETLIS_HIER107COLUMN_ETLIS_COL108REPORT_ETLIS_REP109DOCUMENT_ETLIS_DOC110FILTER_ETLIS_FILT111TEMPLATE_ETLIS_TEMP112METRIC_ETLIS_MET113CUSTOM GROUP_ETLIS_CUST_GP114CONSOLIDATION_ETLIS_CONS115PROMPT_ETLIS_PROMPT116SERVER DEFINITION_ETLIS_SERVER117EVENT_ETLIS_EVENT118SCHEDULE_ETLIS_SCHED119FACT_ETLIS_FACT120ATTRIBUTE_ETLIS_ATT121USER GROUP_ETLEM_USR_GP122DB INSTANCE_ETLIS_DB_INST123DB TABLE_ETLIS_DB_TAB124SECURITY FILTER_ETLIS_SEC_FILT125TRANSMITTER_ETLIS_TRANSMIT126DEVICE_ETLIS_DEVICE127DB INSTANCE1_ETLIS_DB_INST1CharacterDescription#AThe name of the attribute under which the subtotal appears.#PThe name of the attribute to the left of, or above the attribute under which the subtotal appears.#0All the forms of the parent element.#1The first form of the parent element reading from left to right or from top to bottom.#2The second form of the parent element reading from left to right or from top to bottom.#3The third form of the parent element reading from left to right or from top to bottom.#4The fourth form of the parent element reading from left to right or from top to bottom.

Custom group that displays Top 10 Customers and Bottom 5 Items
EM_ITEM_IDEM_ITEM_NAMEEM_ITEM_TABLE1USEREM_USER2PROJECTIS_PROJ3ATTRIBUTE FORMIS_ATT_FORM4TABLEIS_TABLE5TRANSFORMATIONIS_TRANS6HIERARCHYIS_HIER7COLUMNIS_COL8REPORTIS_REP9DOCUMENTIS_DOC10FILTERIS_FILT11TEMPLATEIS_TEMP12METRICIS_MET13CUSTOM GROUPIS_CUST_GP14CONSOLIDATIONIS_CONS15PROMPTIS_PROMPT16SERVER DEFINITIONIS_SERVER17EVENTIS_EVENT18SCHEDULEIS_SCHED19FACTIS_FACT20ATTRIBUTEIS_ATT21USER GROUPEM_USR_GP22DB INSTANCEIS_DB_INST23DB TABLEIS_DB_TAB24SECURITY FILTERIS_SEC_FILT25TRANSMITTERIS_TRANSMIT26DEVICEIS_DEVICE27DB INSTANCE1IS_DB_INST1101USER_ETLEM_USER102PROJECT_ETLIS_PROJ103ATTRIBUTE FORM_ETLIS_ATT_FORM104TABLE_ETLIS_TABLE105TRANSFORMATION_ETLIS_TRANS106HIERARCHY_ETLIS_HIER107COLUMN_ETLIS_COL108REPORT_ETLIS_REP109DOCUMENT_ETLIS_DOC110FILTER_ETLIS_FILT111TEMPLATE_ETLIS_TEMP112METRIC_ETLIS_MET113CUSTOM GROUP_ETLIS_CUST_GP114CONSOLIDATION_ETLIS_CONS115PROMPT_ETLIS_PROMPT116SERVER DEFINITION_ETLIS_SERVER117EVENT_ETLIS_EVENT118SCHEDULE_ETLIS_SCHED119FACT_ETLIS_FACT120ATTRIBUTE_ETLIS_ATT121USER GROUP_ETLEM_USR_GP122DB INSTANCE_ETLIS_DB_INST123DB TABLE_ETLIS_DB_TAB124SECURITY FILTER_ETLIS_SEC_FILT125TRANSMITTER_ETLIS_TRANSMIT126DEVICE_ETLIS_DEVICE127DB INSTANCE1_ETLIS_DB_INST1CharacterDescription#AThe name of the attribute under which the subtotal appears.#PThe name of the attribute to the left of, or above the attribute under which the subtotal appears.#0All the forms of the parent element.#1The first form of the parent element reading from left to right or from top to bottom.#2The second form of the parent element reading from left to right or from top to bottom.#3The third form of the parent element reading from left to right or from top to bottom.#4The fourth form of the parent element reading from left to right or from top to bottom.

Custom group that displays Top 10 Customers and Bottom 5 Items
EM_ITEM_IDEM_ITEM_NAMEEM_ITEM_TABLE1USEREM_USER2PROJECTIS_PROJ3ATTRIBUTE FORMIS_ATT_FORM4TABLEIS_TABLE5TRANSFORMATIONIS_TRANS6HIERARCHYIS_HIER7COLUMNIS_COL8REPORTIS_REP9DOCUMENTIS_DOC10FILTERIS_FILT11TEMPLATEIS_TEMP12METRICIS_MET13CUSTOM GROUPIS_CUST_GP14CONSOLIDATIONIS_CONS15PROMPTIS_PROMPT16SERVER DEFINITIONIS_SERVER17EVENTIS_EVENT18SCHEDULEIS_SCHED19FACTIS_FACT20ATTRIBUTEIS_ATT21USER GROUPEM_USR_GP22DB INSTANCEIS_DB_INST23DB TABLEIS_DB_TAB24SECURITY FILTERIS_SEC_FILT25TRANSMITTERIS_TRANSMIT26DEVICEIS_DEVICE27DB INSTANCE1IS_DB_INST1101USER_ETLEM_USER102PROJECT_ETLIS_PROJ103ATTRIBUTE FORM_ETLIS_ATT_FORM104TABLE_ETLIS_TABLE105TRANSFORMATION_ETLIS_TRANS106HIERARCHY_ETLIS_HIER107COLUMN_ETLIS_COL108REPORT_ETLIS_REP109DOCUMENT_ETLIS_DOC110FILTER_ETLIS_FILT111TEMPLATE_ETLIS_TEMP112METRIC_ETLIS_MET113CUSTOM GROUP_ETLIS_CUST_GP114CONSOLIDATION_ETLIS_CONS115PROMPT_ETLIS_PROMPT116SERVER DEFINITION_ETLIS_SERVER117EVENT_ETLIS_EVENT118SCHEDULE_ETLIS_SCHED119FACT_ETLIS_FACT120ATTRIBUTE_ETLIS_ATT121USER GROUP_ETLEM_USR_GP122DB INSTANCE_ETLIS_DB_INST123DB TABLE_ETLIS_DB_TAB124SECURITY FILTER_ETLIS_SEC_FILT125TRANSMITTER_ETLIS_TRANSMIT126DEVICE_ETLIS_DEVICE127DB INSTANCE1_ETLIS_DB_INST1CharacterDescription#AThe name of the attribute under which the subtotal appears.#PThe name of the attribute to the left of, or above the attribute under which the subtotal appears.#0All the forms of the parent element.#1The first form of the parent element reading from left to right or from top to bottom.#2The second form of the parent element reading from left to right or from top to bottom.#3The third form of the parent element reading from left to right or from top to bottom.#4The fourth form of the parent element reading from left to right or from top to bottom.

Custom group that displays Top 10 Customers and Bottom 5 Items
EM_ITEM_IDEM_ITEM_NAMEEM_ITEM_TABLE1USEREM_USER2PROJECTIS_PROJ3ATTRIBUTE FORMIS_ATT_FORM4TABLEIS_TABLE5TRANSFORMATIONIS_TRANS6HIERARCHYIS_HIER7COLUMNIS_COL8REPORTIS_REP9DOCUMENTIS_DOC10FILTERIS_FILT11TEMPLATEIS_TEMP12METRICIS_MET13CUSTOM GROUPIS_CUST_GP14CONSOLIDATIONIS_CONS15PROMPTIS_PROMPT16SERVER DEFINITIONIS_SERVER17EVENTIS_EVENT18SCHEDULEIS_SCHED19FACTIS_FACT20ATTRIBUTEIS_ATT21USER GROUPEM_USR_GP22DB INSTANCEIS_DB_INST23DB TABLEIS_DB_TAB24SECURITY FILTERIS_SEC_FILT25TRANSMITTERIS_TRANSMIT26DEVICEIS_DEVICE27DB INSTANCE1IS_DB_INST1101USER_ETLEM_USER102PROJECT_ETLIS_PROJ103ATTRIBUTE FORM_ETLIS_ATT_FORM104TABLE_ETLIS_TABLE105TRANSFORMATION_ETLIS_TRANS106HIERARCHY_ETLIS_HIER107COLUMN_ETLIS_COL108REPORT_ETLIS_REP109DOCUMENT_ETLIS_DOC110FILTER_ETLIS_FILT111TEMPLATE_ETLIS_TEMP112METRIC_ETLIS_MET113CUSTOM GROUP_ETLIS_CUST_GP114CONSOLIDATION_ETLIS_CONS115PROMPT_ETLIS_PROMPT116SERVER DEFINITION_ETLIS_SERVER117EVENT_ETLIS_EVENT118SCHEDULE_ETLIS_SCHED119FACT_ETLIS_FACT120ATTRIBUTE_ETLIS_ATT121USER GROUP_ETLEM_USR_GP122DB INSTANCE_ETLIS_DB_INST123DB TABLE_ETLIS_DB_TAB124SECURITY FILTER_ETLIS_SEC_FILT125TRANSMITTER_ETLIS_TRANSMIT126DEVICE_ETLIS_DEVICE127DB INSTANCE1_ETLIS_DB_INST1CharacterDescription#AThe name of the attribute under which the subtotal appears.#PThe name of the attribute to the left of, or above the attribute under which the subtotal appears.#0All the forms of the parent element.#1The first form of the parent element reading from left to right or from top to bottom.#2The second form of the parent element reading from left to right or from top to bottom.#3The third form of the parent element reading from left to right or from top to bottom.#4The fourth form of the parent element reading from left to right or from top to bottom.

Custom group that displays Top 10 Customers and Bottom 5 Items
EM_ITEM_IDEM_ITEM_NAMEEM_ITEM_TABLE1USEREM_USER2PROJECTIS_PROJ3ATTRIBUTE FORMIS_ATT_FORM4TABLEIS_TABLE5TRANSFORMATIONIS_TRANS6HIERARCHYIS_HIER7COLUMNIS_COL8REPORTIS_REP9DOCUMENTIS_DOC10FILTERIS_FILT11TEMPLATEIS_TEMP12METRICIS_MET13CUSTOM GROUPIS_CUST_GP14CONSOLIDATIONIS_CONS15PROMPTIS_PROMPT16SERVER DEFINITIONIS_SERVER17EVENTIS_EVENT18SCHEDULEIS_SCHED19FACTIS_FACT20ATTRIBUTEIS_ATT21USER GROUPEM_USR_GP22DB INSTANCEIS_DB_INST23DB TABLEIS_DB_TAB24SECURITY FILTERIS_SEC_FILT25TRANSMITTERIS_TRANSMIT26DEVICEIS_DEVICE27DB INSTANCE1IS_DB_INST1101USER_ETLEM_USER102PROJECT_ETLIS_PROJ103ATTRIBUTE FORM_ETLIS_ATT_FORM104TABLE_ETLIS_TABLE105TRANSFORMATION_ETLIS_TRANS106HIERARCHY_ETLIS_HIER107COLUMN_ETLIS_COL108REPORT_ETLIS_REP109DOCUMENT_ETLIS_DOC110FILTER_ETLIS_FILT111TEMPLATE_ETLIS_TEMP112METRIC_ETLIS_MET113CUSTOM GROUP_ETLIS_CUST_GP114CONSOLIDATION_ETLIS_CONS115PROMPT_ETLIS_PROMPT116SERVER DEFINITION_ETLIS_SERVER117EVENT_ETLIS_EVENT118SCHEDULE_ETLIS_SCHED119FACT_ETLIS_FACT120ATTRIBUTE_ETLIS_ATT121USER GROUP_ETLEM_USR_GP122DB INSTANCE_ETLIS_DB_INST123DB TABLE_ETLIS_DB_TAB124SECURITY FILTER_ETLIS_SEC_FILT125TRANSMITTER_ETLIS_TRANSMIT126DEVICE_ETLIS_DEVICE127DB INSTANCE1_ETLIS_DB_INST1CharacterDescription#AThe name of the attribute under which the subtotal appears.#PThe name of the attribute to the left of, or above the attribute under which the subtotal appears.#0All the forms of the parent element.#1The first form of the parent element reading from left to right or from top to bottom.#2The second form of the parent element reading from left to right or from top to bottom.#3The third form of the parent element reading from left to right or from top to bottom.#4The fourth form of the parent element reading from left to right or from top to bottom.

Custom group that displays Top 10 Customers and Bottom 5 Items
EM_ITEM_IDEM_ITEM_NAMEEM_ITEM_TABLE1USEREM_USER2PROJECTIS_PROJ3ATTRIBUTE FORMIS_ATT_FORM4TABLEIS_TABLE5TRANSFORMATIONIS_TRANS6HIERARCHYIS_HIER7COLUMNIS_COL8REPORTIS_REP9DOCUMENTIS_DOC10FILTERIS_FILT11TEMPLATEIS_TEMP12METRICIS_MET13CUSTOM GROUPIS_CUST_GP14CONSOLIDATIONIS_CONS15PROMPTIS_PROMPT16SERVER DEFINITIONIS_SERVER17EVENTIS_EVENT18SCHEDULEIS_SCHED19FACTIS_FACT20ATTRIBUTEIS_ATT21USER GROUPEM_USR_GP22DB INSTANCEIS_DB_INST23DB TABLEIS_DB_TAB24SECURITY FILTERIS_SEC_FILT25TRANSMITTERIS_TRANSMIT26DEVICEIS_DEVICE27DB INSTANCE1IS_DB_INST1101USER_ETLEM_USER102PROJECT_ETLIS_PROJ103ATTRIBUTE FORM_ETLIS_ATT_FORM104TABLE_ETLIS_TABLE105TRANSFORMATION_ETLIS_TRANS106HIERARCHY_ETLIS_HIER107COLUMN_ETLIS_COL108REPORT_ETLIS_REP109DOCUMENT_ETLIS_DOC110FILTER_ETLIS_FILT111TEMPLATE_ETLIS_TEMP112METRIC_ETLIS_MET113CUSTOM GROUP_ETLIS_CUST_GP114CONSOLIDATION_ETLIS_CONS115PROMPT_ETLIS_PROMPT116SERVER DEFINITION_ETLIS_SERVER117EVENT_ETLIS_EVENT118SCHEDULE_ETLIS_SCHED119FACT_ETLIS_FACT120ATTRIBUTE_ETLIS_ATT121USER GROUP_ETLEM_USR_GP122DB INSTANCE_ETLIS_DB_INST123DB TABLE_ETLIS_DB_TAB124SECURITY FILTER_ETLIS_SEC_FILT125TRANSMITTER_ETLIS_TRANSMIT126DEVICE_ETLIS_DEVICE127DB INSTANCE1_ETLIS_DB_INST1CharacterDescription#AThe name of the attribute under which the subtotal appears.#PThe name of the attribute to the left of, or above the attribute under which the subtotal appears.#0All the forms of the parent element.#1The first form of the parent element reading from left to right or from top to bottom.#2The second form of the parent element reading from left to right or from top to bottom.#3The third form of the parent element reading from left to right or from top to bottom.#4The fourth form of the parent element reading from left to right or from top to bottom.

Custom group that displays Top 10 Customers and Bottom 5 Items
EM_ITEM_IDEM_ITEM_NAMEEM_ITEM_TABLE1USEREM_USER2PROJECTIS_PROJ3ATTRIBUTE FORMIS_ATT_FORM4TABLEIS_TABLE5TRANSFORMATIONIS_TRANS6HIERARCHYIS_HIER7COLUMNIS_COL8REPORTIS_REP9DOCUMENTIS_DOC10FILTERIS_FILT11TEMPLATEIS_TEMP12METRICIS_MET13CUSTOM GROUPIS_CUST_GP14CONSOLIDATIONIS_CONS15PROMPTIS_PROMPT16SERVER DEFINITIONIS_SERVER17EVENTIS_EVENT18SCHEDULEIS_SCHED19FACTIS_FACT20ATTRIBUTEIS_ATT21USER GROUPEM_USR_GP22DB INSTANCEIS_DB_INST23DB TABLEIS_DB_TAB24SECURITY FILTERIS_SEC_FILT25TRANSMITTERIS_TRANSMIT26DEVICEIS_DEVICE27DB INSTANCE1IS_DB_INST1101USER_ETLEM_USER102PROJECT_ETLIS_PROJ103ATTRIBUTE FORM_ETLIS_ATT_FORM104TABLE_ETLIS_TABLE105TRANSFORMATION_ETLIS_TRANS106HIERARCHY_ETLIS_HIER107COLUMN_ETLIS_COL108REPORT_ETLIS_REP109DOCUMENT_ETLIS_DOC110FILTER_ETLIS_FILT111TEMPLATE_ETLIS_TEMP112METRIC_ETLIS_MET113CUSTOM GROUP_ETLIS_CUST_GP114CONSOLIDATION_ETLIS_CONS115PROMPT_ETLIS_PROMPT116SERVER DEFINITION_ETLIS_SERVER117EVENT_ETLIS_EVENT118SCHEDULE_ETLIS_SCHED119FACT_ETLIS_FACT120ATTRIBUTE_ETLIS_ATT121USER GROUP_ETLEM_USR_GP122DB INSTANCE_ETLIS_DB_INST123DB TABLE_ETLIS_DB_TAB124SECURITY FILTER_ETLIS_SEC_FILT125TRANSMITTER_ETLIS_TRANSMIT126DEVICE_ETLIS_DEVICE127DB INSTANCE1_ETLIS_DB_INST1CharacterDescription#AThe name of the attribute under which the subtotal appears.#PThe name of the attribute to the left of, or above the attribute under which the subtotal appears.#0All the forms of the parent element.#1The first form of the parent element reading from left to right or from top to bottom.#2The second form of the parent element reading from left to right or from top to bottom.#3The third form of the parent element reading from left to right or from top to bottom.#4The fourth form of the parent element reading from left to right or from top to bottom.

Custom group that displays Top 10 Customers and Bottom 5 Items
EM_ITEM_IDEM_ITEM_NAMEEM_ITEM_TABLE1USEREM_USER2PROJECTIS_PROJ3ATTRIBUTE FORMIS_ATT_FORM4TABLEIS_TABLE5TRANSFORMATIONIS_TRANS6HIERARCHYIS_HIER7COLUMNIS_COL8REPORTIS_REP9DOCUMENTIS_DOC10FILTERIS_FILT11TEMPLATEIS_TEMP12METRICIS_MET13CUSTOM GROUPIS_CUST_GP14CONSOLIDATIONIS_CONS15PROMPTIS_PROMPT16SERVER DEFINITIONIS_SERVER17EVENTIS_EVENT18SCHEDULEIS_SCHED19FACTIS_FACT20ATTRIBUTEIS_ATT21USER GROUPEM_USR_GP22DB INSTANCEIS_DB_INST23DB TABLEIS_DB_TAB24SECURITY FILTERIS_SEC_FILT25TRANSMITTERIS_TRANSMIT26DEVICEIS_DEVICE27DB INSTANCE1IS_DB_INST1101USER_ETLEM_USER102PROJECT_ETLIS_PROJ103ATTRIBUTE FORM_ETLIS_ATT_FORM104TABLE_ETLIS_TABLE105TRANSFORMATION_ETLIS_TRANS106HIERARCHY_ETLIS_HIER107COLUMN_ETLIS_COL108REPORT_ETLIS_REP109DOCUMENT_ETLIS_DOC110FILTER_ETLIS_FILT111TEMPLATE_ETLIS_TEMP112METRIC_ETLIS_MET113CUSTOM GROUP_ETLIS_CUST_GP114CONSOLIDATION_ETLIS_CONS115PROMPT_ETLIS_PROMPT116SERVER DEFINITION_ETLIS_SERVER117EVENT_ETLIS_EVENT118SCHEDULE_ETLIS_SCHED119FACT_ETLIS_FACT120ATTRIBUTE_ETLIS_ATT121USER GROUP_ETLEM_USR_GP122DB INSTANCE_ETLIS_DB_INST123DB TABLE_ETLIS_DB_TAB124SECURITY FILTER_ETLIS_SEC_FILT125TRANSMITTER_ETLIS_TRANSMIT126DEVICE_ETLIS_DEVICE127DB INSTANCE1_ETLIS_DB_INST1CharacterDescription#AThe name of the attribute under which the subtotal appears.#PThe name of the attribute to the left of, or above the attribute under which the subtotal appears.#0All the forms of the parent element.#1The first form of the parent element reading from left to right or from top to bottom.#2The second form of the parent element reading from left to right or from top to bottom.#3The third form of the parent element reading from left to right or from top to bottom.#4The fourth form of the parent element reading from left to right or from top to bottom.

Custom group that displays Top 10 Customers and Bottom 5 Items
EM_ITEM_IDEM_ITEM_NAMEEM_ITEM_TABLE1USEREM_USER2PROJECTIS_PROJ3ATTRIBUTE FORMIS_ATT_FORM4TABLEIS_TABLE5TRANSFORMATIONIS_TRANS6HIERARCHYIS_HIER7COLUMNIS_COL8REPORTIS_REP9DOCUMENTIS_DOC10FILTERIS_FILT11TEMPLATEIS_TEMP12METRICIS_MET13CUSTOM GROUPIS_CUST_GP14CONSOLIDATIONIS_CONS15PROMPTIS_PROMPT16SERVER DEFINITIONIS_SERVER17EVENTIS_EVENT18SCHEDULEIS_SCHED19FACTIS_FACT20ATTRIBUTEIS_ATT21USER GROUPEM_USR_GP22DB INSTANCEIS_DB_INST23DB TABLEIS_DB_TAB24SECURITY FILTERIS_SEC_FILT25TRANSMITTERIS_TRANSMIT26DEVICEIS_DEVICE27DB INSTANCE1IS_DB_INST1101USER_ETLEM_USER102PROJECT_ETLIS_PROJ103ATTRIBUTE FORM_ETLIS_ATT_FORM104TABLE_ETLIS_TABLE105TRANSFORMATION_ETLIS_TRANS106HIERARCHY_ETLIS_HIER107COLUMN_ETLIS_COL108REPORT_ETLIS_REP109DOCUMENT_ETLIS_DOC110FILTER_ETLIS_FILT111TEMPLATE_ETLIS_TEMP112METRIC_ETLIS_MET113CUSTOM GROUP_ETLIS_CUST_GP114CONSOLIDATION_ETLIS_CONS115PROMPT_ETLIS_PROMPT116SERVER DEFINITION_ETLIS_SERVER117EVENT_ETLIS_EVENT118SCHEDULE_ETLIS_SCHED119FACT_ETLIS_FACT120ATTRIBUTE_ETLIS_ATT121USER GROUP_ETLEM_USR_GP122DB INSTANCE_ETLIS_DB_INST123DB TABLE_ETLIS_DB_TAB124SECURITY FILTER_ETLIS_SEC_FILT125TRANSMITTER_ETLIS_TRANSMIT126DEVICE_ETLIS_DEVICE127DB INSTANCE1_ETLIS_DB_INST1CharacterDescription#AThe name of the attribute under which the subtotal appears.#PThe name of the attribute to the left of, or above the attribute under which the subtotal appears.#0All the forms of the parent element.#1The first form of the parent element reading from left to right or from top to bottom.#2The second form of the parent element reading from left to right or from top to bottom.#3The third form of the parent element reading from left to right or from top to bottom.#4The fourth form of the parent element reading from left to right or from top to bottom.

Custom group that displays Top 10 Customers and Bottom 5 Items
EM_ITEM_IDEM_ITEM_NAMEEM_ITEM_TABLE1USEREM_USER2PROJECTIS_PROJ3ATTRIBUTE FORMIS_ATT_FORM4TABLEIS_TABLE5TRANSFORMATIONIS_TRANS6HIERARCHYIS_HIER7COLUMNIS_COL8REPORTIS_REP9DOCUMENTIS_DOC10FILTERIS_FILT11TEMPLATEIS_TEMP12METRICIS_MET13CUSTOM GROUPIS_CUST_GP14CONSOLIDATIONIS_CONS15PROMPTIS_PROMPT16SERVER DEFINITIONIS_SERVER17EVENTIS_EVENT18SCHEDULEIS_SCHED19FACTIS_FACT20ATTRIBUTEIS_ATT21USER GROUPEM_USR_GP22DB INSTANCEIS_DB_INST23DB TABLEIS_DB_TAB24SECURITY FILTERIS_SEC_FILT25TRANSMITTERIS_TRANSMIT26DEVICEIS_DEVICE27DB INSTANCE1IS_DB_INST1101USER_ETLEM_USER102PROJECT_ETLIS_PROJ103ATTRIBUTE FORM_ETLIS_ATT_FORM104TABLE_ETLIS_TABLE105TRANSFORMATION_ETLIS_TRANS106HIERARCHY_ETLIS_HIER107COLUMN_ETLIS_COL108REPORT_ETLIS_REP109DOCUMENT_ETLIS_DOC110FILTER_ETLIS_FILT111TEMPLATE_ETLIS_TEMP112METRIC_ETLIS_MET113CUSTOM GROUP_ETLIS_CUST_GP114CONSOLIDATION_ETLIS_CONS115PROMPT_ETLIS_PROMPT116SERVER DEFINITION_ETLIS_SERVER117EVENT_ETLIS_EVENT118SCHEDULE_ETLIS_SCHED119FACT_ETLIS_FACT120ATTRIBUTE_ETLIS_ATT121USER GROUP_ETLEM_USR_GP122DB INSTANCE_ETLIS_DB_INST123DB TABLE_ETLIS_DB_TAB124SECURITY FILTER_ETLIS_SEC_FILT125TRANSMITTER_ETLIS_TRANSMIT126DEVICE_ETLIS_DEVICE127DB INSTANCE1_ETLIS_DB_INST1CharacterDescription#AThe name of the attribute under which the subtotal appears.#PThe name of the attribute to the left of, or above the attribute under which the subtotal appears.#0All the forms of the parent element.#1The first form of the parent element reading from left to right or from top to bottom.#2The second form of the parent element reading from left to right or from top to bottom.#3The third form of the parent element reading from left to right or from top to bottom.#4The fourth form of the parent element reading from left to right or from top to bottom.

Custom group that displays Top 10 Customers and Bottom 5 Items
EM_ITEM_IDEM_ITEM_NAMEEM_ITEM_TABLE1USEREM_USER2PROJECTIS_PROJ3ATTRIBUTE FORMIS_ATT_FORM4TABLEIS_TABLE5TRANSFORMATIONIS_TRANS6HIERARCHYIS_HIER7COLUMNIS_COL8REPORTIS_REP9DOCUMENTIS_DOC10FILTERIS_FILT11TEMPLATEIS_TEMP12METRICIS_MET13CUSTOM GROUPIS_CUST_GP14CONSOLIDATIONIS_CONS15PROMPTIS_PROMPT16SERVER DEFINITIONIS_SERVER17EVENTIS_EVENT18SCHEDULEIS_SCHED19FACTIS_FACT20ATTRIBUTEIS_ATT21USER GROUPEM_USR_GP22DB INSTANCEIS_DB_INST23DB TABLEIS_DB_TAB24SECURITY FILTERIS_SEC_FILT25TRANSMITTERIS_TRANSMIT26DEVICEIS_DEVICE27DB INSTANCE1IS_DB_INST1101USER_ETLEM_USER102PROJECT_ETLIS_PROJ103ATTRIBUTE FORM_ETLIS_ATT_FORM104TABLE_ETLIS_TABLE105TRANSFORMATION_ETLIS_TRANS106HIERARCHY_ETLIS_HIER107COLUMN_ETLIS_COL108REPORT_ETLIS_REP109DOCUMENT_ETLIS_DOC110FILTER_ETLIS_FILT111TEMPLATE_ETLIS_TEMP112METRIC_ETLIS_MET113CUSTOM GROUP_ETLIS_CUST_GP114CONSOLIDATION_ETLIS_CONS115PROMPT_ETLIS_PROMPT116SERVER DEFINITION_ETLIS_SERVER117EVENT_ETLIS_EVENT118SCHEDULE_ETLIS_SCHED119FACT_ETLIS_FACT120ATTRIBUTE_ETLIS_ATT121USER GROUP_ETLEM_USR_GP122DB INSTANCE_ETLIS_DB_INST123DB TABLE_ETLIS_DB_TAB124SECURITY FILTER_ETLIS_SEC_FILT125TRANSMITTER_ETLIS_TRANSMIT126DEVICE_ETLIS_DEVICE127DB INSTANCE1_ETLIS_DB_INST1CharacterDescription#AThe name of the attribute under which the subtotal appears.#PThe name of the attribute to the left of, or above the attribute under which the subtotal appears.#0All the forms of the parent element.#1The first form of the parent element reading from left to right or from top to bottom.#2The second form of the parent element reading from left to right or from top to bottom.#3The third form of the parent element reading from left to right or from top to bottom.#4The fourth form of the parent element reading from left to right or from top to bottom.

Custom group that displays Top 10 Customers and Bottom 5 Items
EM_ITEM_IDEM_ITEM_NAMEEM_ITEM_TABLE1USEREM_USER2PROJECTIS_PROJ3ATTRIBUTE FORMIS_ATT_FORM4TABLEIS_TABLE5TRANSFORMATIONIS_TRANS6HIERARCHYIS_HIER7COLUMNIS_COL8REPORTIS_REP9DOCUMENTIS_DOC10FILTERIS_FILT11TEMPLATEIS_TEMP12METRICIS_MET13CUSTOM GROUPIS_CUST_GP14CONSOLIDATIONIS_CONS15PROMPTIS_PROMPT16SERVER DEFINITIONIS_SERVER17EVENTIS_EVENT18SCHEDULEIS_SCHED19FACTIS_FACT20ATTRIBUTEIS_ATT21USER GROUPEM_USR_GP22DB INSTANCEIS_DB_INST23DB TABLEIS_DB_TAB24SECURITY FILTERIS_SEC_FILT25TRANSMITTERIS_TRANSMIT26DEVICEIS_DEVICE27DB INSTANCE1IS_DB_INST1101USER_ETLEM_USER102PROJECT_ETLIS_PROJ103ATTRIBUTE FORM_ETLIS_ATT_FORM104TABLE_ETLIS_TABLE105TRANSFORMATION_ETLIS_TRANS106HIERARCHY_ETLIS_HIER107COLUMN_ETLIS_COL108REPORT_ETLIS_REP109DOCUMENT_ETLIS_DOC110FILTER_ETLIS_FILT111TEMPLATE_ETLIS_TEMP112METRIC_ETLIS_MET113CUSTOM GROUP_ETLIS_CUST_GP114CONSOLIDATION_ETLIS_CONS115PROMPT_ETLIS_PROMPT116SERVER DEFINITION_ETLIS_SERVER117EVENT_ETLIS_EVENT118SCHEDULE_ETLIS_SCHED119FACT_ETLIS_FACT120ATTRIBUTE_ETLIS_ATT121USER GROUP_ETLEM_USR_GP122DB INSTANCE_ETLIS_DB_INST123DB TABLE_ETLIS_DB_TAB124SECURITY FILTER_ETLIS_SEC_FILT125TRANSMITTER_ETLIS_TRANSMIT126DEVICE_ETLIS_DEVICE127DB INSTANCE1_ETLIS_DB_INST1CharacterDescription#AThe name of the attribute under which the subtotal appears.#PThe name of the attribute to the left of, or above the attribute under which the subtotal appears.#0All the forms of the parent element.#1The first form of the parent element reading from left to right or from top to bottom.#2The second form of the parent element reading from left to right or from top to bottom.#3The third form of the parent element reading from left to right or from top to bottom.#4The fourth form of the parent element reading from left to right or from top to bottom.

ka04W000001IwKuQAK_0EM440000002F8p.jpeg

 
To define a specific subtotal displays for a report like the one shown above, follow the steps below:
 

  • Select Subtotals from the Data menu. The Subtotals dialog box opens.
  • 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. In this case, only one form exists for each, as shown below:
ka04W000001IwKuQAK_0EM440000002F8r.jpeg
  • 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.
  • Click OK to save the new subtotal.
  • Click OK to return to the Subtotals dialog box.
  • Click OK.

The report now should look like this:
 

ka04W000001IwKuQAK_0EM440000002F8l.jpeg

 

Comment

0 comments

Details

Knowledge Article

Published:

June 1, 2017

Last Updated:

August 24, 2022