Loading

Table Calculation Filter Shows Extra Data After ​Adding Grand Totals

Udgivelsesdato: Feb 23, 2026
Beskrivelse

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. 
Løsning
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.

 
Vidensartikelnummer

001534891

Vedhæftede filer

tablea filter issue.twbx

1168 KB

 
Indlæser
Salesforce Help | Article