Filtering DataPilot Tables
Možete koristiti filtere da uklonite neželjene podatke iz DataPilot tabele.
Kliknite Filtar tipku u tablici da pozovete dijaloški prozor za uslove filtera. Alternativno, pozovite kontekstualni meni DataPilot tabele i izaberite Filtar komandu. Filtar dijaloški prozor se pojavi. Ovdje možete filtrirati DataPilot tabelu.
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.
-
The pop-up window displays a list of field members associated with that field. A check box is placed to the left of each field member name. When a field has an alternative display name that differs from its original name, that name is displayed in the list.
-
Enable or disable a checkbox to show or hide the associated field member in the pivot table.
-
Enable or disable the All checkbox to show all or none of the field members.
-
Select a field member in the pop-up window and click the
button to show only the selected field member. All other field members are hidden in the pivot table. -
Select a field member in the pop-up window and click the
button to hide only the selected field member. All other field members are shown in the pivot table. -
Commands enable you to sort the field members in ascending order, descending order, or using a custom sort list.
-
Odaberite dokument sa NaredbaCtrl+F6 i pritisnite Tab
-
The arrow to open the pop-up window is normally black. When the field contains one or more hidden field members, the arrow is blue and displays a tiny square at its lower-right corner.
-
Možete kliknuti na stranicu Pomoći i pritisnuti NaredbaCtrl+F.