![]() ![]() ![]() ![]() You cannot drill down in flat hierarchies (such as hierarchies that show attributes of the same item but don’t provide data on a next level) or other hierarchies that don’t have data on multiple levels. Keep using Quick Explore until you reach the data you want. Now you see subcategory data for that item (Accessory products, in this case). In the Explore box, pick the item you want to explore, and click Drill Down. You can drill down only one item at a time.Ĭlick the Quick Explore button that appears in the lower-right corner of the selection. In your OLAP cube or Data Model PivotTable, pick an item (like Accessories in our example) in the field (like the Category field in our example). You typically start by drilling down to the next level in the hierarchy. The button shows up whenever you select an item in a field. Quick Explore helps you navigate to the data you want to see, and acts like a filter when you drill down. In Excel 2013, the new Quick Explore feature lets you drill into your Online Analytical Processing (OLAP) cube or Data Model-based PivotTable hierarchy to analyze data details on different levels. Drilling into large amounts of data in a PivotTable hierarchy has always been a time-consuming task with lots of expanding, collapsing, and filtering. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |