You’re gonna learn all the tips the pros use, so get ready for a very very long post! Highlight the items and then right click and select Group from the menu.
Download the example file with the data used in this post to follow along. You can select multiple non-adjacent field items by holding the key while making your selection.
You can use the Search from within a pivot table filter to add items to your previously selected items.
You can filter items in a field from the field list in the Pivot Table Fields window.
Fields containing text data will be added to the Rows section and fields containing numeric data will be added to the Values section when using the check box.
They’re one of Excel’s most powerful features, they allow you to quickly summarize large amounts of data in a matter of seconds. This will count as a different name but visually it will look the same as the old field name.
This collection of awesome tips and tricks will help you master pivot tables and become a data ninja! You can group items in a field together to further summarize your data.