Pivot Table
Specify the layout of the table that is generated by the pivot table.
The pivot table displays data fields as buttons which you can drag and drop to define the pivot table.
āĻŦāĻŋāύā§āϝāĻžāϏ
To define the layout of a pivot table, drag and drop data field buttons onto the Page Fields, Row Fields, Column Fields, and Data Fields areas. You can also use drag and drop to rearrange the data fields on a pivot table.
LibreOffice āϏā§āĻŦā§āĻāĻā§āϰāĻŋā§āĻāĻžāĻŦā§ āĻāĻāĻāĻŋ āĻā§āϝāĻžāĻĒāĻļāύ āĻāĻāĻāĻŋ āĻŦā§āϤāĻžāĻŽā§ āϏāĻāϝā§āĻā§āϤ āĻāϰāϤ⧠āĻĒāĻžāϰ⧠āϝāĻž āϤāĻĨā§āϝ āĻā§āώā§āϤā§āϰ āĻāϞāĻžāĻāĻžāϤ⧠āĻĻā§āύ⧠āύāĻŋāϝāĻŧā§ āĻāϏāĻž āĻšāϝāĻŧāĨ¤ āĻļāĻŋāϰā§āύāĻžāĻŽāĻāĻŋ āϤāĻĨā§āϝ āĻā§āώā§āϤā§āϰā§āϰ āύāĻžāĻŽāĻāĻŋ āϧāĻžāϰāĻŖ āĻāϰ⧠āϏāĻžāĻĨā§ āϏāĻžāĻĨā§ āĻāĻāĻāĻŋ āϏā§āϤā§āϰ āĻšāĻŋāϏāĻžāĻŦā§ āϝāĻž āϤāĻĨā§āϝ āϤā§āϰāĻŋ āĻāϰā§āĻā§āĨ¤
āϤāĻĨā§āϝ āĻā§āώā§āϤā§āϰ āĻĻā§āĻŦāĻžāϰāĻž āĻŦā§āϝāĻŦāĻšā§āϤ āĻāĻāĻāĻŋ āĻĢāĻžāĻāĻļāύ āĻĒāϰāĻŋāĻŦāϰā§āϤāύ āĻāϰāĻžāϰ āĻāύā§āϝ, āϤāĻĨā§āϝ āĻā§āώā§āϤā§āϰ āĻāϞāĻĻāĻžāĻāĻžāϤ⧠āĻāĻāĻāĻŋ āĻŦā§āϤāĻžāĻŽā§ āĻĄāĻžāĻŦāϞ-āĻā§āϞāĻŋāĻ āĻāϰā§āύ āϝāĻžāϤ⧠āϤāĻĨā§āϝ āĻā§āώā§āϤā§āϰ āĻĄāĻžāϝāĻŧāĻžāϞāĻāĻāĻŋ āĻā§āϞāĻž āϝāĻžāϝāĻŧāĨ¤ āĻāĻĒāύāĻŋ āĻāϰāĻ āϏāĻžāϰāĻŋ āĻā§āώā§āϤā§āϰ āĻ āĻĨāĻŦāĻž āĻāϞāĻžāĻŽ āĻā§āώā§āϤā§āϰ āĻāϞāĻžāĻāĻžāϤ⧠āĻŦā§āϤāĻžāĻŽā§ āĻĄāĻžāĻŦāϞ-āĻā§āϞāĻŋāĻ āĻāϰāϤ⧠āĻĒāĻžāϰā§āύāĨ¤
āĻ āϧāĻŋāĻ
Displays or hides additional options for defining the pivot table.
āĻĢāϞāĻžāĻĢāϞ
Specify the settings for displaying the results of the pivot table.
āύāĻŋāϰā§āĻŦāĻžāĻāύ āĻĢāϰāĻŽ
Select the area that contains the data for the current pivot table.
āĻĢāϞāĻžāĻĢāϞ
Select the area where you want to display the results of the pivot table.
If the selected area contains data, the pivot table overwrites the data. To prevent the loss of existing data, let the pivot table automatically select the area to display the results.
āĻļā§āύā§āϝ āϏāĻžāϰāĻŋ āĻāĻĒā§āĻā§āώāĻž āĻāϰā§āύ
āϤāĻĨā§āϝ āĻā§āϏ⧠āĻļā§āύā§āϝ āĻā§āϏā§āϤā§āϰ āĻāĻĒā§āĻā§āώāĻž āĻāϰā§āĨ¤
āĻļā§āϰā§āĻŖā§āĻŦāĻŋāĻāĻžāĻ āϏāύāĻžāĻā§āϤ āĻāϰā§āύ
āĻāĻĒāϰā§āϰ āϏāĻžāϰāĻŋāϰ āĻļā§āϰā§āĻŖā§āĻŦāĻŋāĻāĻžāĻā§āϰ āĻĻāĻŋāĻā§ āϞā§āĻŦā§āϞ āĻŦā§āϝāϤā§āϤ āϏā§āĻŦā§āĻāĻā§āϰāĻŋā§āĻāĻžāĻŦā§ āϏāĻžāϰāĻŋ āĻŦāϰāĻžāĻĻā§āĻĻ āĻāϰā§āĨ¤
āϏāϰā§āĻŦāĻŽā§āĻ āĻāϞāĻžāĻŽ
āĻāϞāĻžāĻŽ āĻāĻŖāύāĻžāϰ āϏāϰā§āĻŦāĻŽā§āĻ āĻĒāϰāĻŋāĻŽāĻžāĻŖ āĻšāĻŋāϏāĻžāĻŦ āĻāϰ⧠āĻāĻŦāĻ āĻĒā§āϰāĻĻāϰā§āĻļāύ āĻāϰā§āĨ¤
āϏāϰā§āĻŦāĻŽā§āĻ āϏāĻžāϰāĻŋ
āϏāĻžāϰāĻŋ āĻāĻŖāύāĻžāϰ āϏāϰā§āĻŦāĻŽā§āĻ āĻĒāϰāĻŋāĻŽāĻžāĻŖ āĻšāĻŋāϏāĻžāĻŦ āĻāϰ⧠āĻāĻŦāĻ āĻĒā§āϰāĻĻāϰā§āĻļāύ āĻāϰā§āĨ¤
āĻĒāϰāĻŋāĻļā§āϧāĻ āϏāĻāϝā§āĻā§āϤ āĻāϰā§āύ
Adds a Filter button to pivot tables that are based on spreadsheet data.
āĻĒāϰāĻŋāĻļā§āϧāĻ āĻĄāĻžāϝāĻŧāĻžāϞāĻ āĻā§āϞā§āύāĨ¤
āĻŦāĻŋāϏā§āϤāĻžāϰāĻŋāϤ āĻŦāϰā§āĻŖāύāĻžāϰ āĻāύā§āϝ āĻĄā§āϰāĻŋāϞ āϏāĻā§āϰāĻŋāϝāĻŧ āĻāϰā§āύ
āĻāĻ āĻĒāϰā§āĻā§āώāĻž āĻŦāĻžāĻā§āϏāĻāĻŋ āύāĻŋāϰā§āĻŦāĻžāĻāύ āĻāϰā§āύ āĻāĻŦāĻ āĻāĻāĻāĻŋ āĻā§āĻŦāĻŋāϞ⧠āĻāĻĒāĻžāĻĻāĻžāύā§āϰ āĻāύā§āϝ āĻŦāĻŋāϏā§āϤāĻžāϰāĻŋāϤ āĻĒā§āϰāĻĻāϰā§āĻļāύ āĻāĻŦāĻ āϞāĻŋāĻāĻžāύā§āϰ āĻāύā§āϝ āĻāĻĒāĻžāĻĻāĻžāύ āϞā§āĻŦā§āϞ āĻĄāĻžāĻŦāϞ-āĻā§āϞāĻŋāĻ āĻāϰā§āύāĨ¤ āĻĒāϰā§āĻā§āώāĻž āĻŦāĻžāĻā§āϏāĻāĻŋ āĻā§āϞāĻŋāϝāĻŧāĻžāϰ āĻāϰā§āύ āĻāĻŦāĻ āĻāϰā§āϰ āĻāĻĒāĻžāĻĻāĻžāύ āϏāĻŽā§āĻĒāĻžāĻĻāύāĻž āĻāϰāĻžāϰ āĻāύā§āϝ āĻā§āĻŦāĻŋāϞ⧠āĻāĻāĻāĻŋ āĻāϰ⧠āĻĄāĻžāĻŦāϞ-āĻā§āϞāĻŋāĻ āĻāϰā§āύāĨ¤
āĻāĻāĻāĻŋ DataPilot āĻā§āĻŦāĻŋāϞā§āϰ āĻŽāϧā§āϝ⧠āĻŦāĻŋāϏā§āϤāĻžāϰāĻŋāϤ āύāĻŋāϰā§āĻā§āώāĻž āĻāϰāĻžāϰ āĻāύā§āϝ
āύāĻŋāĻŽā§āύā§āϰ āϝā§āĻā§āύ⧠āĻāĻāĻāĻŋ āĻāϰā§āύ:
-
āĻāϰ āĻĒāϰāĻŋāϏāϰ āύāĻŋāϰā§āĻŦāĻžāĻāύ āĻāϰā§āύ āĻāĻŦāĻ āϤāĻĨā§āϝ - āĻā§āϰā§āĻĒ āĻāĻŦāĻ āĻŦāĻšāĻŋāϰā§āĻŦāĻŋāύā§āϝāĻžāϏ - āĻŦāĻŋāϏā§āϤāĻžāϰāĻŋāϤ āĻĒā§āϰāĻĻāϰā§āĻļāύ āĻĒāĻāύā§āĻĻ āĻāϰā§āύāĨ¤
-
āĻā§āĻŦāĻŋāϞā§āϰ āĻāĻāĻāĻŋ āĻā§āώā§āϤā§āϰ⧠āĻĄāĻžāĻŦāϞ-āĻā§āϞāĻŋāĻ āĻāϰā§āύāĨ¤
āϝāĻĻāĻŋ āĻāĻĒāύāĻŋ āĻāĻāĻāĻŋ āĻā§āώā§āϤā§āϰ⧠āĻĄāĻžāĻŦāϞ-āĻā§āϞāĻŋāĻ āĻāϰā§āύ āϝāĻžāϰ āĻāĻāĻ āϞā§āĻŦā§āϞ⧠āĻāĻāĻāĻŋ āύāĻŋāĻāĻāĻŦāϰā§āϤ⧠āĻā§āώā§āϤā§āϰ āϰāϝāĻŧā§āĻā§, āĻŦāĻŋāϏā§āϤāĻžāϰāĻŋāϤ āĻĒā§āϰāĻĻāϰā§āĻļāύ āĻĄāĻžāϝāĻŧāĻžāϞāĻāĻāĻŋ āĻā§āϞā§:
āĻŦāĻŋāϏā§āϤāĻžāϰāĻŋāϤ āĻŦāϰā§āĻŖāύāĻž āĻĒā§āϰāĻĻāϰā§āĻļāύ āĻāϰā§āύ
āĻā§āώā§āϤā§āϰ āĻĒāĻāύā§āĻĻ āĻāϰā§āύ āϝāĻž āĻāĻĒāύāĻŋ āĻŦāĻŋāϏā§āϤāĻžāϰāĻŋāϤ āĻāϰ āĻāύā§āϝ āĻĒā§āϰāĻĻāϰā§āĻļāύ āĻāϰāϤ⧠āĻāĻžāύāĨ¤