Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-23-2016, 12:10 AM
lamdalamda lamdalamda is offline Quick Explore drill-down order question Windows 8 Quick Explore drill-down order question Office 2013
Novice
Quick Explore drill-down order question
 
Join Date: Jun 2016
Posts: 1
lamdalamda is on a distinguished road
Default Quick Explore drill-down order question

So I've put together a report and I've used the Quick Explore function to group together 4 fields. Lets say that these for fields are Country/Region/State/City. I have used Quick Explore to link all 4 together into 1 field and the rest of the fields to the right are all metrics based upon these.



The issue I am having is when I collapse all to the top level so that just Countries are showing, when I click the + button, it opens up the whole hierarchy down to the City level. So it opens up the entire thing. Is there a way to order this so that the + sign in when at the Country level only opens up the Region level? Then the Region only opens up to the State, then State to City? I want people to have to click from one to the next, not just have it open up the whole thing with one click.

Any suggestions on this would be greatly appreciated!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Quick Explore drill-down order question Quick Question on Pivot Tables; how to PivotFilter3133 Excel 2 02-09-2015 08:07 AM
Pivot Table Question- Can the table display in the order the boxes were checked/selected? blackjack Excel 0 09-13-2014 08:57 PM
Quick Explore drill-down order question Word 2013: Building Blocks / Quick Parts - Form Question EGoetz Word VBA 2 12-05-2013 09:09 PM
Quick Explore drill-down order question Quick Question jordan_Circle Outlook 2 08-23-2011 06:32 PM
Quick Explore drill-down order question Duration help (Quick question) davy631 Project 3 03-07-2011 12:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft