Loading

How To Apply A Filter Only To A Single Measure In The View

Julkaisupäivä: Apr 13, 2024
Tehtävä

How to apply a filter only to a single measure in the view. Example: Showing Sales for a selected category and Total sales

Vaiheet
1. Use Fixed calculation for the measure you do not want to be affected by filter. Example: Total Sales would be { Fixed: Sum( Sales) }
2. Use Sum(Sales) as it is for the other measure 
3. Use the Category filter. This will filter sum of sales and not the Total Sales
User-added image
 
Knowledge-artikkelin numero

001453833

Liitteet

Example-2018.1.twbx

1189 KB

 
Ladataan
Salesforce Help | Article