篩選樞紐分析表

您可以使用篩選器來從樞紐分析表移除不想見到的資料。

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:

D'oh! You found a bug (text/scalc/guide/datapilot_edittable.xhp#datapilot_edittable not found).

D'oh! You found a bug (text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable not found).

Please support us!