![]() The pivot table may seem a bit complicated, and does not give insights at a glance. You can expand the rows you are interested in while keeping the rows in the rest of the table collapsed. The pivot table is very powerful when you want to analyze multiple dimensions and measures at once, and then reorganize them to get a different perspective on your data. The pivot table is useful when you want to include several dimensions or measures in a single table, and then want to reorganize them to see different subtotals. You can rearrange measures and dimensions by pivoting rows and columns. In a pivot table you can analyze data by multiple measures and in multiple dimensions at the same time. The pivot table presents dimensions and measures as rows and columns in a table. Creating a bookmark with an expanded pivot table.Pivoting your data in the properties panel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |