Loading

Filter View by Grand Total Value

Publiceringsdatum: Apr 13, 2024
Uppgift
How to filter a view based on the value of the Grand Total.
Steg
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.
Ytterligare resurser
The above steps can be reviewed in the attached workbook filtergrandtotal.twbx.
Knowledge-artikelnummer

001456653

Bilagor

filtergrandtotal.twbx

1195 KB

 
Laddar
Salesforce Help | Article