pivot table
Pivot Table Reports
หรือใช้คีย์ลัด ALT + F5 หลัง จากคลิกเลือกเซลใดก็ได้ใน Pivot Table Update Pivot Table by Changing the Data Source If you've added new rowscolumns
A Pivot Table is used to summarise, sort, reorganise, group, count, total or average data stored in a table It allows us to transform columns into rows and Change the Aggregation Type for a Column All similar rows in a DataSet are automatically aggregated in a Pivot Table The default aggregation
d365 Go to the Analyze tab and press the Options button found under the PivotTable section to open the PivotTable Option Then go to the Data tab and select None Creating a pivot table · From the assets panel, drag an empty pivot table to the sheet · Click Add dimension and select a dimension or a field · Click Add