Filtering Pivot Tables

आप फ़िल्टरों का इस्तेमाल डाटा-पायलट तालिका से अवांछित डाटा को मिटाने के लिए कर सकते हैं.

Click the Filter button in the sheet to call up the dialog for the filter conditions. Alternatively, call up the context menu of the pivot table and select the Filter command. The Filter dialog appears. Here you can filter the pivot table.

You can also click the arrow on a button in the pivot table to show a pop-up window. In this pop-up window, you can edit the visibility settings of the associated field.

Open file with example:

Please support us!