Choose a Custom Name for that field. Sorting PivotTable Data To sort a PivotTable report: Click within the field in the PivotTable that you wish to sort by. Data Sort Choose the sort order; the options available will depend on the data in the field. For example, numerical values can be sorted Largest to Smallest or visa-versa. TIP: Selecting a subtotal allows you to sort by subtotals instead of individual items. Grouping a Field Items in the Row Labels or Column Labels areas of a PivotTable report can be grouped to summarise the data and make it more readable. Numbers can be grouped into different intervals. For example you may wish to group marks into specific categories (e.g. 0-10, 10-20 etc.) and add a count of those marks to ∑ Values area of the report to create a frequency distribution table for marks. Perhaps the most common way of grouping data is to group dates together. Dates (and times) can be grouped on a variety of intervals, for example, day, month, quarter or year. To group a field: Click within the field of the PivotTable that you wish to group: PivotTable Tools Analyze Group Selection. Choose the start and end options for grouping (the default values are usually acceptable) then choose how your groups will be setup. Use the Ctrl key to select multiple options (e.g. Months and Years): More Information:
Choose a Custom Name for that field. Sorting PivotTable Data To sort a PivotTable report: Click within the field in the PivotTable that you wish to sort by. Data Sort Choose the sort order; the options available will depend on the data in the field. For example, numerical values can be sorted Largest to Smallest or visa-versa. TIP: Selecting a subtotal allows you to sort by subtotals instead of individual items. Grouping a Field Items in the Row Labels or Column Labels areas of a PivotTable report can be grouped to summarise the data and make it more readable. Numbers can be grouped into different intervals. For example you may wish to group marks into specific categories (e.g. 0-10, 10-20 etc.) and add a count of those marks to ∑ Values area of the report to create a frequency distribution table for marks. Perhaps the most common way of grouping data is to group dates together. Dates (and times) can be grouped on a variety of intervals, for example, day, month, quarter or year. To group a field: Click within the field of the PivotTable that you wish to group: PivotTable Tools Analyze Group Selection. Choose the start and end options for grouping (the default values are usually acceptable) then choose how your groups will be setup. Use the Ctrl key to select multiple options (e.g. Months and Years): More Information:
How%20To%20Guide%20-%20Intermediate%20Excel%202013.docx