Filter Metrics using Comparison feature

At times there is a need to display the value of a metric with a filter sub-set of data.

For example comparing the value of Beverage Sales to all Sales..
 
The wokbook below shows the result of this implemented by using a comparison filter.

 

image007-2.png

To create this column do the following

  1. Use [+Add] a comparison filter
  2. set the type to Manual
  3. use [ Y+]  to add a Category filter for example.  
  4. Set the to the desire filte value eg Beverage

If you need a different date range or additional filters they can be added as required. 

 

 

image008.png
 

 

From Marcelo Colling

Was this article helpful?
0 out of 0 found this helpful

Articles in this section

Ask the BI4 Community
Need help using this report or feature?