Once you have created the groups you can name them anything you like. Because the group names are, by default, Group 1 and Group 2, you will need to edit these to rename them - to do this, click in the cell that contains the group name and in the Formula Bar type over the group name with a more descriptive name. Using this tool you can group data into smaller collections that make sense to you.
![excel 2011 mac pivot table excel 2011 mac pivot table](https://i.ytimg.com/vi/HzNRUI9UML8/hqdefault.jpg)
When you have multiple field names selected you can group them into groups that make sense to you. You can now go ahead and select other row entries that belong to the next group and create a group for them. From the PivotTable Options tab on the Ribbon, select Group Selection and those items will be added to a new group. With the PivotTable on the screen, click in the first item of data that is part of a group and then Ctrl + Click on each other item that belongs in that group. In this case, you can create your own groupings for your data. Sometimes a group is a group simply because you say that it is so.
#EXCEL 2011 MAC PIVOT TABLE SERIES#
Sometimes it's not possible to allocate a group to a series of records as simply as describing a numerical sequence or a date sequence. You'll then have data grouped by week.Ī large amount of data is to be grouped into weeks (7 days), starting on a Sunday - the day of the Starting At date. To do this, select Days as the grouping value, set the number of days to 7, set the Starting At value to a date that you know to be the beginning of a week and click Ok. For groupings like Year and Month the interval is set to 1, but for Days you can set your own interval so you can group at an interval of 7 Days to group data into weeks. You can group by Seconds, Minutes, Hours, Days, Months, Quarters or Years and set the starting and ending times. To group the data by date, right click on a date in a column or row of your PivotTable and choose Group. If the data that you are looking at is date data then you can do something similar. Here is the data grouped by OrderID so it's more summarized than before. The data is now grouped into more manageable chunks based on the OrderID. Here we've set the Starting At value, we've left the Ending At value for Excel to manage and we've left the By value at 10 as this works for our data - you can make groups larger or smaller by changing this value - to, say 5, 20, 50 or 100 and then click Ok. Here we're setting up the parameters for grouping the data - it will be grouped by OrderID into groups of ten consecutively numbered orders. To start at 10240, type this value into the Starting At box - you can set the starting point wherever you like even if that value doesn't exist in your data. However you can create a neater or different grouping by setting your own Starting At value. The default Starting At value that Excel offers is the first OrderID: 10248. Right now Excel is suggesting you group the items in multiples of ten starting at the Starting value.
![excel 2011 mac pivot table excel 2011 mac pivot table](https://aspoyae.weebly.com/uploads/1/2/4/7/124796997/450615366.jpg)
As the Order ID is a numerical field the dialog will be already configured for numerical grouping with a Starting At, an Ending At and a By value. 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.
![excel 2011 mac pivot table excel 2011 mac pivot table](https://www.techonthenet.com/excel/pivottbls/images/gtotal_col2011_001.gif)
You can summarize the invoices by grouping the invoices together into groups of 5,10 or even 100 invoices. Grouping and Multiple Consolidation RangesĬonsider the situation where your PivotTable data includes a series of invoices that you are analyzing.
#EXCEL 2011 MAC PIVOT TABLE HOW TO#
This can be done by grouping the data and in this post I'll explain how to do this. When you're working with a PivotTable in Excel you may find that you have a lot of data in the table that needs to be summarized even further. Helen Bradley explains how to group data in Excel PivotTables to help further summarize and analyze your data.