Use the Data Field dialog to select the calculations to be used for the data. ![]() By double-clicking on one of the fields in the Data Fields area you can call up the Data Field dialog.If the button is dropped in the Data Fields area it will be given a caption that also shows the formula that will be used to calculate the data. You can use drag-and-drop within the generated pivot table to use another page field as a filter. The listbox can be used to filter the pivot table by the contents of the selected item. Drag the desired buttons into one of the four areas.ĭrag a button to the Page Fields area to create a button and a listbox on top of the generated pivot table.Drag these buttons as required and drop them into the layout areas "Page Fields", "Column Fields", "Row Fields" and "Data Fields". The table headings are shown as buttons in the Pivot Table dialog. ![]() Choose Current selection and confirm with OK.
0 Comments
Leave a Reply. |