How do I create a report filter in pages?

Select any cell inside the pivot table. Select the Options/Analyze contextual ribbon tab. Click the drop-down arrow to the right of the Options button on the left side. Click the Show Report Filter Pages…

Why is my pivot table option greyed out?

If all buttons are greyed out, it certainly looks like the workbook is shared or the sheet protected. Otherwise, it might be a one-time glitch.

How do you filter a report in Excel?

Click anywhere in the PivotTable (or the associated PivotTable of a PivotChart ) that has one or more report filters. Click PivotTable Analyze (on the ribbon) > Options > Show Report Filter Pages. In the Show Report Filter Pages dialog box, select a report filter field, and then click OK.

How do I turn a PivotTable into a report?

Manually create a PivotTable

1. Click a cell in the source data or table range.
2. Go to Insert > PivotTable.
3. Excel will display the Create PivotTable dialog with your range or table name selected.
4. In the Choose where you want the PivotTable report to be placed section, select New Worksheet, or Existing Worksheet.

How do you refresh data in a PivotTable?

Manually refresh

1. Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon.
2. Click Analyze > Refresh, or press Alt+F5. Tip: To update all PivotTables in your workbook at once, click Analyze > Refresh All.

How do I filter a report in Salesforce?

Filter a Report in Salesforce Classic

1. On the Reports tab, click a report to open it.
2. Click Customize.
3. Click Add and select a Field Filter from the list. A new filter row appears below the other two filters.
4. Click.
5. Select an operator for the filter and type the filter value in the next field.
6. Click Save.

Why is calculated field greyed out?

It is grayed out because the source is OLAP, however there is a work around. Drop the data into Excel into a table. If you try to pivot off this data, the calculated field will still be grayed out.