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 Show only the current item 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 Hide only the current item 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 +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 +F.

Open file with example: