Loading

Filter View by Grand Total Value

Publiseringsdato: Apr 13, 2024
Oppgave
How to filter a view based on the value of the Grand Total.
Trinn
Aggregate the measure up to the level of detail of the grand total using a calculation similar to the following: 

IF { EXCLUDE [Ship Date]:SUM([Profit]) }<40000 THEN 'yes'
else 'no'
END


Put this calculation on the filters shelf as an 'attribute' and filter out all but 'yes'.

In this specific example, whenever the grand total is less than 40000 only this row will be displayed.
Flere ressurser
The above steps can be reviewed in the attached workbook filtergrandtotal.twbx.
Knowledge-artikkelnummer

001456653

Vedlegg

filtergrandtotal.twbx

1195 KB

 
Laster
Salesforce Help | Article