Loading

Filter View by Grand Total Value

Дата публикации: Apr 13, 2024
Задача
How to filter a view based on the value of the Grand Total.
Действия
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.
Дополнительные ресурсы
The above steps can be reviewed in the attached workbook filtergrandtotal.twbx.
Номер статьи базы знаний

001456653

Вложения

filtergrandtotal.twbx

1195 KB

 
Загрузка
Salesforce Help | Article