Derived metric based on attribute values

Derived metric based on attribute values

Here is how could create and display data correctly on using below simple steps. 

1. Create a report with Category, Subcategory and Revenue.
2. Create New Metric in a report or VI. 
3. Case((Category@ID = 1), Revenue, 0) Booksand Name it as Revenue for where 2 is Category ID for "Books" 
4. Report will display result as below.
   
5.  Result for new metric is blank. Now to fix this create a new Derived metric on Category attribute first with formula as Max(Category) {~ }  and calling Books
6. Now Edit the "Revenue for Books metric and Replace Category@ID with this new Books metric formula would looks like this Case((Books = 1), Revenue, 0). 
7. Report result would now display as expected as shown below