#1
|
|||
|
|||
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! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
Word 2013: Building Blocks / Quick Parts - Form Question | EGoetz | Word VBA | 2 | 12-05-2013 09:09 PM |
Quick Question | jordan_Circle | Outlook | 2 | 08-23-2011 06:32 PM |
Duration help (Quick question) | davy631 | Project | 3 | 03-07-2011 12:55 PM |