![]() ![]() For example, it doesn't make sense to have Product appear above Category. Note that the order that the fields appear is reflected in the pivot table. Let's remove Region and add Category under products. Product sales are now grouped by Region first, and then State. In this same way, we can look at product sales by region and state by adding State to the Column labels area. We can just drag the fields to swap locations.Īnd drag them back again to restore the original orientation. In this pivot table, we have the Product field in the Row Labels area and Region in the Column Labels areas. The easiest way to move a field is just to drag it from one area to another. Each time you move a field, the pivot table will rebuild itself to respect the new field configuration. When you're working with a pivot table, you can move fields from one area to another at any time. This is where the idea of Pivot comes from. Each time you move a field, you see another view of the same data, in a different orientation. Moving fields around in a pivot table is fun and even addictive.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |