Creating a Calculation that Ignores Filters Use the level of detail (LOD) expression FIXED . Follow the steps below: Drag [Region] onto the Rows shelf. Drag [Sales] onto Text on the marks card. Drag [Category] onto the Filters shelf. In the Edit Filter dialog, check all categories and click OK . Right-click [Category] on the Filters shelf and select Show Filter . Select Analysi s > Create Calculated Field . In the Calculated Field dialog box that opens, do the following, and then click OK : Name the calculated field. In this example, the calculated field is named "Unfiltered Sales" In the formula field, create a calculation similar to the following: { FIXED [Region] : SUM( [Sales] ) } Double-click [Unfiltered Sales] in the Data pane to add the field to the crosstab.