You may need to display a calculation that includes both the data that the table displays, and the data that is present in the data provider but not currently displayed in the table. The only way to achieve this is to force Web Intelligence to ignore a report filter or ranking that is applied to an object or variable in the data provider.
Use the NoFilter() function to override a report filter or ranking. NoFilter() includes all the values of a variable in the data provider in the calculation, even if the data does not display in the table or block.
The syntax for the NoFilter() function is as follows:
NoFilter(object)
Report Filter or Ranking Override – An Example
See the following video to learn more about the Use of the No Filter() Function.