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.
To create this column do the following
- Use [+Add] a comparison filter
- set the type to Manual
- use [ Y+] to add a Category filter for example.
- 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.
From Marcelo Colling