Category: Excel Tables

When you add or change the data source that your Pivot Tables are built on, you need to refresh your Pivot Table, otherwise the Pivot Table will not reflect …

In Excel, when drag date variable to the Row box, dates will automatically generate two new variables: "Years" and "Quarters", and data will be grouped by "Years". However, you …

You can group the items after you make a Pivot Table, please see below for details. In this example, we are going to group "Region" into two groups: East …

After making a Pivot Table, you can add one or more filters to customize the data summaries. Step 1: Drag "Gender" to the "Report Filter" box; Step 2: In …

Not only you can sort the Pivot Table in the alphabetical order, but also you can move around to have a mixed special order. For example, when sorting "Region" from …

In most situations, Pivot Table can be sorted in the same way as other regular data tables (see how to make a simple Pivot Table): Step 1: Move your …