Pivot table use a large set of data to create detailed summaries. When you adjust pivot table settings, filters can be added to pivot tables to quickly filter the data. Columns containing a filter display a filter drop-down arrow editor_filter_on_drop_active in the column header.

Customizing pivot tables and creating filters in the web version of MyOffice application is under development and will be available in the further versions.

To filter data in a pivot table:

1.Select editor_filter_on_drop_active in the column heading.

2.In the settings window that opens, select the field whose values you want to filter and check the se_editor_filter_dlg_listl_chkbox_selected boxes next to the values you want to display in the table. Repeat the operation for all required fields.

3.Click the OK button to apply the filter. Or click Cancel to cancel the selection and close the filter setting window.

Was the material useful?
Users found this material useful: 0 из 0