Loading

Table Calculation Filter Shows Extra Data After ​Adding Grand Totals

Дата публикации: Feb 23, 2026
Описание

Table calculation filter (e.g. LOOKUP filter) does not work well when ​adding the Grand Total

For example, when using table calculation filter -- LOOKUP filter -- to show the Percentage Difference from the previous year, it works well to show only one year's data.
User-added image

However, after adding Grand Total, other years' grand total also show up.
User-added image
 

Cause

This behavior is by design. 
Решение
Please use the [Apply to Totals] Option in the filter, and the table calculation filter will also apply to Grand totals
User-added image

Please also check the attached workbook for details.

 
Дополнительные ресурсы
Filtering the View Without Filtering Underlying Data
Номер статьи базы знаний

001534891

Вложения

tablea filter issue.twbx

1168 KB

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