View Single Post
 
Old 06-23-2016, 12:10 AM
lamdalamda lamdalamda is offline Windows 8 Office 2013
Novice
 
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