To do this, right click one of the Order IDs in the PivotTable and choose Group. In this PivotTable each individual OrderID is represented in one row of the table, this is summarized data but not highly so. Right now there is one row for each order which is cumbersome - we can group these to simplify the table. So, consider this example where the Order ID is a row label and a numeric field. You can summarize the invoices by grouping the invoices together into groups of 5,10 or even 100 invoices.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |