Loading

Filter View by Grand Total Value

Julkaisupäivä: Apr 13, 2024
Tehtävä
How to filter a view based on the value of the Grand Total.
Vaiheet
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.
Lisäresurssit
The above steps can be reviewed in the attached workbook filtergrandtotal.twbx.
Knowledge-artikkelin numero

001456653

Liitteet

filtergrandtotal.twbx

1195 KB

 
Ladataan
Salesforce Help | Article