![]() ![]() There are a few ways you can add the fields. Values (Fields go here containing number values you can then calculate).Rows (Fields go here to be displayed in row format).Columns (Fields go here to be displayed in column format).Filters (Fields go here if you want to be able to filter based on them).You have 4 areas to work with within the pivot table area. ![]() What perspective do you want to gain? Do you want a particular field displayed in columns or rows within the pivot table? Do you have a specific field you’d like to be able to filter by within the pivot table? There is no right or wrong location to put each field within the structure as it really comes down to how you want to look at the data. I highly recommend you have a good play with the options. ![]() Now that you have a pivot table area set up and ready, you need to add the fields from your data that you wish to include in the pivot table structure. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |