Peñerar Tables dinámiques

Pues utilizar peñeres pa desaniciar los datos que nun quieras d'una tabla dinámica.

Calca nel botón Peñera de la fueya p'abrir el diálogu de condiciones de filtru. Otra posibilidá ye abrir el menú contestual de la tabla dinámica y escoyer la orde Peñerar. Ábrese'l diálogu Peñera. Pues utilizar dichu diálogu pa peñerar la tabla dinámica.

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.

• Active o desactive un cuadru de comprobación p'amosar o anubrir el miembru del campu asociáu na tabla dinámica.

• Active o desactive la marca de seleición Toos p'amosar o anubrir tolos miembros del campu.

• 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.

• Pa editar les llistes d'ordenación personalizaes, abra - LibreOffice Calc - Ordenar llistes.

• 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.

• Tamién pue abrir la ventana emerxente poniendo'l punteru de caxella nel botón y calcando +D.

Abrir un ficheru d'exemplu: