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
  2. Topics

KB40863: How to use a count metric to filter out attributes in MicroStrategy Developer


Stefan Zepeda

Salesforce Solutions Architect • Strategy


How to use a count metric to filter out attributes inside of a report.

Summary: How to use a count metric to filter out attributes inside of a report.
 
Steps to reproduce:
1. Create a report with Brand and Item on the grid.
 

ka02R000000kcI8QAI_0EM440000002DAn.png

 
2. Create a count metric that counts the Items and has a level (dimensionality) of brand and no report level.
 

ka02R000000kcI8QAI_0EM440000002DAg.png

 
3. Add metric to the Report Filter, and define the metric value as Exactly with a Value of 2.
 

ka02R000000kcI8QAI_0EM440000002DAV.png

 
4. When the report is run, only the Brands with two Items will be returned.
 

ka02R000000kcI8QAI_0EM440000002DAl.png

 


Comment

0 comments

Details

Knowledge Article

Published:

May 15, 2017

Last Updated:

May 15, 2017