Loading

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

Publiseringsdato: Apr 13, 2024
Oppgave

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

Trinn
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-artikkelnummer

001453833

Vedlegg

Example-2018.1.twbx

1189 KB

 
Laster
Salesforce Help | Article