KB439226: How to create a filtered metric using a case statement in Visual Insight in MicroStrategy Web 10.x

INTRODUCTION
This article describes how to create a metric with an attribute as a filter using a Case statement in a Visual Insight dashboard in Strategy Web. 
Content
In order to create a metric in Strategy Visual Insight to filter on a specific attribute, a Case statement function can be used to get the designed results. 

Syntax
Sum(IF((Attribute@ID=Element),Metric,0)){}
Where: 

• Attribute is the attribute being used as a filter 
• Element  is the specific element being filtered on
• Metric is the base metric being used 

REPRODUCING STEPS IN TUTORIAL
1. Create a new derived metric in a VI Dashboard with the formula below: 
Sum(IF((Year@ID=2014),Cost,0)){}
 

2. Add the new derived metric to the grid as shown below: 
 

KB439226