![MicroStrategy Tutorial](/microstrategy/images/microstrategy-mini-logo.jpg)
- MicroStrategy Tutorial
- MicroStrategy - Home
- MicroStrategy - Overview
- MicroStrategy - Environment Setup
- MicroStrategy - Desktop
- MicroStrategy - Architecture
- MicroStrategy - Importing Data
- MicroStrategy - OLAP Services
- MicroStrategy Objects
- Configuration Objects
- MicroStrategy - Public Objects
- MicroStrategy - Schema Objects
- MicroStrategy - Report Objects
- MicroStrategy Basic Reporting
- MicroStrategy - Report Types
- MicroStrategy - Slicing
- MicroStrategy - Dicing
- MicroStrategy - Pivoting
- MicroStrategy - Drilldown
- MicroStrategy - Rollup
- MicroStrategy - Creating Metrics
- MicroStrategy - Nested Metrics
- MicroStrategy Advanced Reporting
- Creating Derived Metrics
- MicroStrategy - Metric Comparison
- MicroStrategy - Creating Filters
- MicroStrategy - Advanced Filters
- Shortcut & Embedded Filters
- MicroStrategy - Refreshing Reports
- MicroStrategy - Intelligent Cubes
- MicroStrategy Dashboards
- Creating a Dashboard
- Formatting a Dashboard
- MicroStrategy - Graph Visualizations
- MicroStrategy - Grid Visualizations
- Heat Map Visualization
- MicroStrategy - N/W Visualization
- Visualization with Multiple Datasets
- Filtering Data in Dashboard
- MicroStrategy - Adding Web Content
- MicroStrategy Office
- Conditional Formatting
- MicroStrategy - Custom Groups
- MicroStrategy - Report Cache Flow
- MicroStrategy - Data Marts
- MicroStrategy - Predictive Models
- MicroStrategy Useful Resources
- MicroStrategy - Quick Guide
- MicroStrategy - Useful Resources
- MicroStrategy - Discussion
MicroStrategy - Creating Derived Metrics
Many times we need calculated metrics which are not already available in the data source. If such situations, metric values can be calculated from the existing metrics, using the create metric option. Thus, creating a derived metric is an approach to create values which we will need frequently in the report but which do not exist in the data source.
Example
In this example, we are going to calculate the total of shipping cost and unit price for a product in the superstore sales data. Following are the steps to calculate it.
Step 1
Let’s create a grip report using superstore sales. The report contains product-sub category as attribute and unit price as well as shipping cost as the metrics.
![Derived Metric 1](/microstrategy/images/derived_metric_1.jpg)
Step 2
Next, right-click near any of the metrics and choose the create metric option. It gives us a window to write the formula for the new metric. Here, write the formula we use in the existing metrics. The formula is as shown in the following screenshot.
![Derived Metric 2](/microstrategy/images/derived_metric_2.jpg)
Step 3
The new metric appears under the list of metric of the data source. We drag it to the existing grid report.
![Derived Metric 3](/microstrategy/images/derived_metric_3.jpg)
To Continue Learning Please Login