![]() The first and last date or time you want to group by. The smallest and largest number to group numeric fields. In the Starting at and Ending at box, enter this (as needed): In the PivotTable, right-click any numeric or date and time field, and click Group. Once grouped together, you can drag the group to your Pivot Table and start your analysis. With time grouping, relationships across time-related fields are automatically detected and grouped together when you add rows of time fields to your PivotTables. ![]() Note: The time grouping feature is new in Excel 2016. ![]() ![]() For example, you may want to group an unwieldy list of dates or times (date and time fields in the PivotTable) into quarters and months, like this: ![]() Grouping data in a PivotTable can help you show a subset of data to analyze. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |