microsoft excel 2010

microsoft excel 2010: Spreadsheets: Filtering a Pivot Table with a Formula

21.07.11Whether you are using the Description Filter or the new Excel 2010 Slicer feature in a pin table, there is really no good way to change the riddle with a formula. Instead, you could add a formula to the original text set and then use that new field in the filter. Unfortunately, you would have to constantly reinvigorate the pivot table in order to get the new filters in the statement. Adding a Formula to the Original Data Set. You would like the whirl table to include values where the time is in the before. Rather than try to filter the pivot table with a formula, you could add a ground to the data set. " The formula would be =C2<=NOW(), as illustrated in Figure 2. When you build the pivot table, move the Include field to the Report Filter (or to a slicer if you are in Excel 2010).

Source: CFO.com Magazine