For instructions to create shortcut metrics, which are a type of derived metric, see the MicroStrategy Web Help. Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. This new metric should have the Level (dimensionality) by Category attribute, as shown below. 9/10. Create a standard report like the following: 3. Search. 17K KB16868: How to use an attribute with more than one word in the name in an apply statement in MicroStrategy Developer 10. In the Datasets panel, click More next to the dataset to add the attribute to and choose Create Attribute. When editing the name of a derived metric (or any other such object), in a Visual Insight document, the name changes on the visualization itself, and the grid panel, but not in the "Dataset Objects" panel: STEPS TO REPRODUCE: 1. The Intelligence Server performs any additional operations requested like subtotals, formatting, derived elements, etc… The data is rendered in the end user browser. You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. Editor Pane: If desired, you can enter the definition of the derived attribute directly into the. 1. Create a Base Report in MicroStrategy Tutorial project. The following procedure describes how to achieve this: Create the highest level filter. Create or include a user defined under a security filter on the same attribute or a different attribute in the same hierarchy. Phoenixier. The Derived Elements Editor opens. Modify the Address form so that it has a descending report sort order. Viewed 13k times. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. This Knowledge Base article describes how to create a derived metric that can use the whole dataset of the report, rather than the default functionality of using the grid dataset using the Lag function as an example. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. In the Datasets panel, click More next to. I will first show how to build this derived attribute in sections, and in the end we will combine all the sections together. See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. many derived tables seem to be “too complex” and not perform as well when using derived tables. Use. Choose Operator as 'Exactly'. The attribute ID columns included in a fact table represent the level at which the facts in that. The Create New Attribute Form dialog box now appears. The Duplicate as. These key attributes denote. These are the steps to reproduce the issue in MicroStrategy Tutorial: Max(){Category} -1 . Create a new derived attribute by right mouse. 3. These groups provide a new view of report data for analysis and formatting purposes. This article describes a situation where using a derived attribute based on an existing metric as a filter on a Visual Insight dashboard causes the Intelligence Server to crash. orYou can create an attribute based on an existing object. Check one of the available forms for the attribute. ACTION: See below for steps to create a derived metric that can calculate lag on the whole dataset of the report. Create attribute 'Date' with three forms: ID, DESC, NONE and their data type are numeric, text and date-time accordingly. In the Create New Form Expression window in the Attribute Editor, select the above table as the source table and use the following ApplySimple statement to define the expression: Applysimple( "#0 '-' #1 '-' #2", ID, Quarter, Year)To create a derived attribute with time information, right-click an attribute and choose Create Time Attributes. An attribute form expression defines what columns in the warehouse are used to represent the attribute form in SQL. In a dashboard, create a metric with this formula: Sum (Revenue){~+}<Favorite_Employees_Filter> Important noteThis report shows the sum of sales for each month, for the previous row and the % change between them. Select the checkbox that corresponds with each attribute you want to generate. Note the picture with the definition. x? Based on the ID column in the LU table to calculate the previous ID:In MicroStrategy Agent, go to Schema Objects > Attributes. Save and close the metric and add it to the report, it should contain the same values as the attribute as shown below: Create a new metric that calculates the max date at. MONTH_DATE) MONTH_DATE, sum (a11. The nested derived metric shows missing data (null value) Glossary. The new form should immediately be included in the attribute's column. Be aware that linking actually replaces the source attribute. The steps below use objects from the MicroStrategy Tutorial project as an example. Open a report in MicroStrategy Developer. FactID is a parameter that forces a calculation to take place on a fact table that. To Create a New Metric Based on an Attribute. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. Cleaning up unused objects is still useful for easier troubleshooting, improving performance and better organization of the dossier content down the line. After running a report with an object prompt, selecting an attribute and then creating a derived element based on said attribute, the next time the report is run, the derived element will not show in MicroStrategy Web. 4. Note that if the selected attribute is on the grid, the attribute will be moved. To create a derived metric. To edit an attribute form, click the tab of the attribute form to switch to it, then define the attribute form as described above. Two new derived elements are created, a blank Group. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement. In the MicroStrategy Tutorial, a report with the Subcategory attribute and the Freight and Discount metrics generates the following SQL (using Microsoft SQL Server): select a13. In the Datasets panel, click More next to the dataset to add the attribute to and choose Create Attribute. Click on the Subtotal drop down list for the. In MicroStrategy Web 10. x: 24. This feature also supports multiple attribute forms. . The filter within the report is created by selecting from an element list as follows: With the report created to filter on a specific Month of Date element selected from a list of elements, the following SQL is generated: select DATEPART (MONTH, a12. In MicroStrategy 10. Click on the "Validate" button to validate the formula. Attributes appear with an attribute icon on the Datasets and Editor panels. Provide details and share your research! But avoid. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. The Metric Formula Editor opens. Matching objects appear in a drop-down as you type. With related attributes however the amount of. To quickly create a derived metric based on an attribute, right-click the attribute, point to Insert Metric, and select the function. Then it creates a third metric, a compound metric. Place the new metric in the desired location, as shown in the screen shot below:MicroStrategy Developer 9. From the Insert menu, select New Metric. Note that for the first row, the data from the previous row is 0 since the analysis is limited to the data retrieved by the report. KB6458: How to create an outer join between two different attributes in MicroStrategy Developer? Number of Views 13. This can help the end user more easily distinguish between elements when browsing or. The Insert Function dialog box opens. Since attributes provide context for fact values, both fact columns and attribute ID columns are included in fact tables. ", Employee@LastName) To Create a Derived Attribute Open the dossier you want to modify. To create a derived attribute with time information, right-click an attribute and choose Create Time Attributes. Check other tables and select/deselect correct tables. Type a name for the derived element, and click OK. from ITEM_MNTH_SLS a11. An attribute may have attribute elements with descriptions that are identical but the ID forms are unique. 1. g. Case. With Architect, you can create and modify multiple attributes in your project quickly from an integrated interface. You can import business data from many different sources, including local files, databases, Google Drive, etc. MicroStrategy platform capabilities exposed in a RESTful web service. However, starting in MicroStrategy 2019 Update 5, you are required to have the "Web Create Derived Metric and Derived Attribute" privilege to edit derived metrics. Visit the data visualization and data dashboard galleries for inspiration. Login MicroStrategy Web, create Subset Report SubR01 based on Intelligent Cube C01; Create Derived Smart Metric DM with expression: Sum (Cost) {~ +} Add into template: Attribute Quarter, Region and Metric DM; Create Subset Report SubR02 based on Intelligent Cube C02, add into template: Attribute Country, Year, Quarter and Metric. Click an object to add it to the definition. g. To create a new Group derived element, from the New drop-down list, select Group. Click Switch to Function Editor. Insert a derived metric 'M01' with expression 'Max(Region@DESC) {~+} '. 16K KB41943: How to create a metric that calculates the distinct count of an attribute. Percent to All -> A1, where A1 is an attribute, indicates that the calculation is performed across all elements of that attribute. This tutorial shows how to create derived attributes and metrics in a dossier. You can create a Year derived attribute from a Date attribute in MMDDYYYY format. Related TopicsUnable to use columns from different tables in a derived attribute in MicroStrategy Developer 9. Add Category attribute to the grid template. 1 and wants to use derived elements to display to display the attribute elements in a specific order. Create a new column alias for the date attribute ID form with the data type 'date'. e. The attribute ID columns included in a fact table represent the level at which the facts in that. Open a report in MicroStrategy Developer. tv. Make your changes, save the metric, and then save and re-execute the report to see the changes in the metric. Using the MicroStrategy Java Web SDK 9. Tutorial project is used here. Next, add Revenue to the Vertical Axis. Open MicroStrategy Developer. The Metric Options dialog opens. 2. The metric, 'Prompt answer' will display the prompt answer on the report, as shown below: NOTE: If the metric 'Prompt answer' returns as blank, remove and re-add the metric, 'Prompt answer' onto the report in design mode. 11, a new feature is available for performance optimization when dealing with derived attributes. When Distinct is set to True, the Count function counts only distinct values. Click an object to add it to the definition. 4. Create derived metric M01 in C01 with level set as attribute Call Ctr Id in C02. Related articles from the Community: Knowledge Base: Is it possible to expose “Create Personal View” subscription option in Presentation mode for users who open a shared Dossier via URL API in MicroStrategy Web 10. Select the Source Table that contains the desired attribute ID, and drag the attribute ID into the Form Expression window. It might not be the solution that you are looking for, I just want to show other things that you can do with derived attributes. Execute the report services document. Add the new derived metric to the grid as shown below:1. The calculation is created as a derived element and displayed on the report. Add the new derived element Category Desc(Group) to the filter panel. We use MicroStrategy Tutorial objects in the following steps. 4. You can create a derived attribute by changing an existing attribute's data type. Select the checkbox that corresponds with each attribute you want to generate. Open the dossier you want to modify. Right click on the attribute, and click edit. There are two methods with to create a stand-alone derived element: Create a derived element from within a report or Grid/Graph and then save it as a stand-alone object. Is it possible to create a. To define a Metric using a text based value prompt, directly type the prompt name with the syntax “? [Text Prompt name]”, for example Max (? [Value (Text)]) and click Validate. 2 is due to a known issue. Choose one of the following: Save the metric. STEP TO REPRODUCE: Create a dashboard with new report, and pick an attribute and two metrics. 4. It means this scenario cannot be applied if your data is imported from Web. Attribute element display locking can be performed at the attribute level and hierarchy level in MicroStrategy Developer 10. Type a new name and press Enter to apply your changes. Add Region to the Color By. To allow the user to choose attributes from a list of attributes that you specify, select . You can also create new attributes, based on existing attributes in your dataset, while viewing a dossier. The main focus of a dossier is the visualizations, which are visual representations of your data. Open the dossier you want to modify. Add DM. To create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. When you import data into MicroStrategy Web, the corresponding dataset is stored with the dossier. To access the Derived Elements Editor for a Grid/Graph in a Report Services document, expand the document section that contains the Grid/Graph. Type the following for the name: "Total for the #P #0". The Metric Editor opens. The syntax of the ApplySimple expression is as follows: ApplySimple ("expression using #0",ATTRIBUTE_NAME)Open a metric editor and create the metric with the following structure: AggregationFunction(case((attribute@AttributeForm="attribute element"), ReturnValue, DefaultValue)) {dimensionality} Users should be sure to specify the attribute form of the attribute that should be used in the calculation. ApplySimple. In later versions of MicroStrategy, you may be shown options for the filter. The. In the New Metric Editor, manually add the metric definition using this expression: max (<attribute>@<form>) {~} The new metric below will display the DESC column of the Country attribute and was created using the metric. You can create a derived attribute by changing an existing attribute's data type. Once the report has run, right click the Category attribute. 1. You can modify the derived element using the Derived Elements Editor. Create a dossier using the above report and create following derived metrics:In the popup dialog box, enter the formula: Count(attribute){} Make sure “Apply selections as a filter” is enabled for the selector. Select the forms you want to see in the card header. These privileges are part of OLAP Services. Create a new Derived Attribute “Day + 1” based on “Day” by right clicking “Day” Attribute and select “Create Attribute”. The Level advanced options dialog box opens. How to create an attribute in MicroStrategy What are attributes? Attributes are groups of related data, such as table columns. Enter the definition of the derived attribute directly into the right pane. Open a report in MicroStrategy Developer. The following procedure illustrates how to retrieve the previous months from a month attribute in MicroStrategy 9. It should work. 11K. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Steps to Create Smart Attributes. To be more specific the product creates a metric dataset for the join between datasets and then outer joins that to the. Symptom MicroStrategy 10. The derived metric aggregates at the level of the attributes on the visualization by default. x. If you have any questions or suggestions for a f. Create a new metric with the following format: Max(‘DD/MM/YYY') {~}. 4. If M1 does not equal V1, then M1 is compared to the next value V2 in the list. On the Background tab in the Format Cells editor and select 'Solid' as background style and choose black as the color for the 'Fill' drop-down. This is a filter which contains a prompt on an attribute element list. Open the dossier you want to modify. If M1 does not equal V1, then M1 is compared to the next value V2 in the list. x. Click OK to return to the Metric Editor. Derived Attribute; CSI; Steps to Reproduce. Refer to the procedure below for steps to create a rank shortcut metric. microstrategy. Select the attributes, then click to return to the Prompt Generation Wizard. Name the derived metric using the top most text field in the window. Use MicroStrategy Web to create customized, interactive dossiers for exploring your business data. Click OK to apply your changes. For information on how to download th. 2, users have the option of removing attributes or metrics from the grid of a Report Services Document executed in Interactive or Editable display mode without losing the. 5. Click Select. Select the heat map visualization. To manually. While knowing your company’s total sales is useful, knowing when and where the sales took place provides the kind of analytical depth that users require on a daily basis. ACTION: This setting can be controlled through the advanced symbols at the end of a conditional derived metric formula. Today, we are covering how to create derived attributes and metrics in MicroStrategy. Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. e. Create a new report 'Dataset' with Attribute 'Category' in row. Related articles from the Community: Knowledge Base: Is it possible to pass filter panel values from one chapter to another using Microstrategy Dossier version 10. Begin to create the derived metric: Using Developer, from the Insert menu in the Report Editor, select New Metric. In this Data in the Wild episode, you'll learn how to create derived metrics and attributes in MicroStrategy. Add External Data. A Calculation derived element uses operators and functions to combine attribute elements and derived elements into calculations that define a single derived element. In the Datasets panel, click More next to the dataset to add the attribute to and choose Create Attribute. Why is this happening?[-] When creating a visualization dashboard within MicroStrategy Web 10. KB39189: How to create a count of different attribute element values using subtotals in MicroStrategy Desktop 9. Click Save and Close to save the metric and close. 2. Assign the Client-Reporter > Web create Derived Metrics and Derived Attributes privilege to the user. Create a second metric, "Zero" as SUM(0), as shown below: Create a compound metric "Count Employee" as "Count Employee temp" + "Zero" with the definition: ( + Zero) Under the "Subtotals/Aggregation" tab, enable the setting "Allow Smart Metric", at the bottom of the pane: Use the compound metric "Count Employee" on the report. Here is the issue: We have an attribute qualification filter that uses . The CaseV function takes a numeric value M1 as input and compares it to another numeric value V1. 2. Open MicroStrategy Web. Attribute level locking constrains the element display in system hierarchy, as shown below:. Derived Attribute; Derived Metric; CurrentDate – A function that returns the current date as provided by the database timer. Open MicroStrategy Web. A derived fact has its value determined by an expression that contains more than just a column in a table. GetNewTransformationMetric (WebMetric, WebObjectInfo) Use. For general instructions to create a derived metric, see Creating derived metrics. See below Image for Reference, I made an assumption that all the values of the column is same and replaced it with column value. The condition is based on either an attribute or metric. We use MicroStrategy Tutorial objects in the following steps. Matching objects appear in a drop-down as you type. Open the dossier you want to modify. g. Create a new bar chart. Create a report named Year Revenue Report with Year attribute on the row and Revenue, Last Year's Revenue & Percentage Change in Revenue metrics on the column and run it as shown below: Notice that the percentage sign (%) is displayed with the values under the Percentage Change in Revenue metric. Enter the definition of the derived. Depending on your MicroStrategy product and licensing. The value prompt is designed to return report results based on the data type assigned to the data in your data source. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. Now, perform the following steps to create the actual transformation: Go to File Menu > New > Transformation, as illustrated below: The new transformation window will open, followed by the "Select a member attribute" window. Create the derived. Source: MicroStrategy. 1/1/2010) that can be used to perform date time functions. ). Attribute form expressions must be rendered into SQL and cannot use any MicroStrategy functions specific to the Analytical Engine. . KB39189: How to create a count of different attribute element values using subtotals in MicroStrategy Desktop 9. Time-derived columns such as "Month of timestamp" or "Day of timestamp" and. 4. 1. x-10. 2. For example, using the MicroStrategy Tutorial project, users may want to calculate the number of. Video Tutorials. Open MicroStrategy Web. From MicroStrategy Education, this lesson teaches you how to. From the 'Edit' menu, choose 'Group'. Visit the data visualization and data dashboard galleries for inspiration. This article describes a situation where using a derived attribute based on an existing metric as a filter on a Visual Insight dashboard causes the Intelligence Server to crash. Unable to use columns from different tables in a derived attribute in MicroStrategy Developer 9. Make: Projects. Once in the report editor, select an attribute and right-click on the attribute header. Create a derived attribute DA2: Choose project attribute “Day” and project metric “Revenue”. Create a filter (Previous Month) using attribute qualification. :. Follow the next steps to create this type of metric. x when joining two datasets together on a document or dashboard data blending is used. x SYMPTOM: Derived attributes are attributes that are based on one or more derived form expressions. This knowledge base article documents how to use derived metrics to concatenate two attribute forms of the report in MicroStrategy 9. 10869. In MicroStrategy 10. 1. 1, and it is currently being evaluated for a potential fix in a future version. Creating derived facts and fact expressions. x. x users can hover over certain objects in the object browser for a description. Click New Threshold. Open up those tables in the Table Editor by navigating to the Schema ObjectsTables folder, and double-clicking the tables. MicroStrategy REST. Insert a derived metric 'M01' with expression 'Max(Region@DESC) {~+} '. Report filters based on attributes unrelated to the attribute in the metric condition are still kept and included in the WHERE clause. Create a derived attribute based on Month and change the data type to String. The attribute must have a date type of Date, Time, or DateTime and contain a date attribute form. Run the document. Derived expressions: Derived form expressions perform some type of mathematical calculation on columns in the data warehouse to create an attribute form. Open up the same document in MicroStrategy Web 10. Article Reference Number: KB39231. Setting 'Mapping method' to 'Manual' forces users to manually select the source tables that use the expression. We use MicroStrategy Tutorial objects to reproduce this issue. A blank page displays and the dynamic text does not show in the document. In the Datasets panel, right-click the metric to use to create a derived metric and choose Create Metric. Symptom 02 . Attributes appear with an attribute icon on the Datasets and Editor panels. In the tab Display, add the ID form in the report display form. Creating derived facts and fact expressions. To manually enter the definition of the derived attribute. Modify the attribute from which the metric is based or base it on a numeric field. com Format: A MicroStrategy Online Training Video blog. For example, you create an attribute called Customer to represent customers in your system, and it is part of the Customer hierarchy. The Input Metric Formula dialog box opens. A dataset enables you to dynamically manipulate the data that appears on a dossier, without having to import a new dataset. x with any number of attributes. 1 : In MicroStrategy Developer, log in to a project. The Level (Dimensionality) definition pane displays below the Metric component area. MicroStrategy can help you with that, with the creation of derived attributes and metrics. Go to the report design view, and insert a new metric (a derived metric). Select "Element/Value Filter". com Format: A MicroStrategy Online Training Video blog. Right click on any of the existing attributes and select Insert Row or scroll down to the bottom of the attributes and place the cursor in the first empty field under Description. They are able to achieve this in the grid report,. The chart below contains a list of all the object types and object descriptions occurring in MicroStrategy metadata: Never used, and all functions should check that zero (0) never pass for a type. This Knowledge Base article describes how to create a derived metric that can use the whole dataset of the report, rather than the default functionality of using the grid dataset using the Lag function as an example. If a derived attribute is based on two or more linked attributes which exists in multiple datasets with different filtering conditions, the derived attribute will subset from the. Create a new Intelligent Cube. Define the advance sort on the derived metric and then sort on Gender DESC. A nested derived attribute is an attribute made from another derived attribute. For conceptual information on attributes as well as detailed examples, see The Context of Your Business Data: Attributes. x. To create a derived metric. If all conditions are false, a default value is returned. To manually enter the definition of the derived attribute. See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. Add Month to the horizontal axis. In the Datasets panel, right-click the attribute to use to create a derived metric and choose Duplicate as Metric. Break byObject: A break by on Object is used to. If the attribute is modeled as an attribute form instead, it is possible to aggregate only at the level of the attribute containing the form. Go to Menu -> Insert -> New Metric, and enter the formula as shown below: Max (Region@DESC) {~ } NOTE: Use Max () function to transfer an attribute form into a. Add, rearrange, or remove data from a visualization in a dossier. x There may be instances when it is necessary to include an attribute form in a derived or a compound metric in order to carry out calculations based on the form value in MicroStrategy Developer 9. Run the report. 2 in Web, navigate to the report in edit mode, right click “customer” and insert metric Count as shown below: 3. For example, in a report with Region and Category attributes and a Profit metric, you can combine the regions on the report into various groups for profit analysis, as shown below. 06K. By adding simple dummy attributes you are able to arrange the columns in a much more tidy form without even touching the original data. All articles. They are metrics that are saved and displayed only on the specific report on which they are created. Login to MicroStrategy Web, go to Add External Data -> Databases -> Pick Tables and pick the following table and columns;. Open MicroStrategy Developer. Click OK to apply your changes. , one condition, a true expression and a false expression -- the MicroStrategy IF function may be used instead. Select the Property tab. Create a derived attribute and reserve it for future use in a visualization. However, you cannot create or modify derived elements for attributes added to the grouping or details sections. Create a report with the prompt created in the previous step. This feature supports big data scenarios where moving large amounts of data to memory is not practical. In MicroStrategy Developer, log in to a project. This feature supports more Big Data scenarios where moving large amounts of data to memory is not practical. Create Derived Attributes and Derived Metrics in the first dataset as below: Derived Attribute Today: CurrentDate Derived Attribute Week: Week ([Today@ID])The following example shows how to create a metric that displays attribute values in MicroStrategy Developer. Select the member attribute as 'Month', as shown below: The "Define a new member attribute expression" window will. x and add a derived attribute, right clicking an. To replace an object (i. In the Create New Form Expression window in the Attribute Editor, select the above table as the source table and use the following ApplySimple statement to define the expression: Applysimple( "#0 '-' #1 '-' #2", ID, Quarter, Year) MicroStrategy Workstation automatically creates attributes when you import data. blogspot. Enter the definition of the derived attribute directly into the right pane. For example, in the MicroStrategy Tutorial project, for the 'Month' attribute, instead of seeing the description as 'September 2007, users might prefer to see 'Sep'. Facts are one of the essential elements within the business data model and basis for almost all metrics. In the Datasets panel, right-click the attribute to use to create a derived metric and choose Duplicate as Metric. x by modifying the object's properties, as shown below: However, when creating a derived metric, no Description field exists, as shown below:. 2. addTransformationMetric (WebTransformationMetric) WebReportManipulation. To add a filter: Open the dossier with the heat map visualization you created in How to Create Your Heat Map Visualization. xCreate a custom subtotal object which is defined with the expression: Count<Distinct=True>(x) {@}, as shown below Create a metric object which is defined as: Max(Customer@ID){~+}, as shown below: Go to the subtotals/aggregation tab of the above created metric and make the subtotal created in Step 1 as the dynamic aggregation. You can also create new attributes, based on existing attributes in your dataset, while viewing a dossier. Add "Products" user hierarchy to the metric level and set the grouping option to "None", as shown below: Create a new report, add item attribute in the row and the metric in step 1 in the column, as shown below:Unlike Value prompts with type of Numeric, in a Text prompt, it is not possible to drag and drop to the Metric Definition pane. Add a filter visualization, and drag Brand to it. 10?; Knowledge Base: How can I filter a visualization on a dossier that users can’t view or manipulate?;. Count<Distinct, FactID, UseLookupForAttributes, Null> (Argument) Argument is an attribute, fact, or metric representing a list of values. STEPS TO REPRODUCE: Create an object prompt, using the pre-defined list of objects and adding the following attributes. SUBCAT_ID SUBCAT_ID,Step 4) Click on data foundation node. Open the dossier you want to modify. Insert one panel stack and add dynamic text with Profit Margin. In the Based On list, select the object to base the threshold on. To allow sorting on the attribute elements after sorting by the metric total value, users may follow the steps below: Create a level derived metric to calculate on the attribute level at which the subtotal is calculated. Check other tables and select/deselect correct tables. Open the dossier you want to modify. g. On the same right mouse click context menu under the attribute header, users will see an. Save the report.