ঘর পরিসর পরিশোধক করা হচ্ছে

Click one of the buttons in the pivot table and hold the mouse button down. A special symbol will appear next to the mouse pointer.

একই সারির ভিন্ন্য অবস্থানে বোতামটি টেনে এনে আপনি কলামের ক্রম পরিবর্তন করতে পারেন। যদি আপনি সারি শীর্ষচরণ এলাকার একটি বোতাম সারণির বাম প্রান্তে টেনে আনেন, আপনি কলাম কে সারিতে পরিবর্তন করতে পারবেন।

In the Pivot Table dialog, you can drag a button to the Page Fields area to create a button and a listbox on top of the pivot table. The listbox can be used to filter the pivot table by the contents of the selected item. You can use drag-and-drop within the pivot table to use another page field as a filter.

To remove a button from the table, just drag it out of the pivot table. Release the mouse button when the mouse pointer positioned within the sheet has become a 'not allowed' icon. The button is deleted.

To edit the pivot table, click a cell inside the pivot table and open the context menu. In the context menu you find the command Edit Layout, which displays the Pivot Table dialog for the current pivot table.

In the pivot table, you can use drag-and-drop or cut/paste commands to rearrange the order of data fields.

You can assign custom display names to fields, field members, subtotals (with some restrictions), and grand totals inside pivot tables. A custom display name is assigned to an item by overwriting the original name with another name.

Open file with example:

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

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

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

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

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