When we double click in team a then it will display only a team and it will not show b and c.
If you don't want 2nd sheet here then go with parameter/filter and filter it.
This is pretty simple. I am assuming that you have the following hierarchy set = Team -> Member Name. Sales will be treated as a Measure, so no need to add it to the hierarchy. You can drop the Sales measure on the Text Shelf on the Marks Card as shown below:
For the drill down, you can create a worksheet level Actions as below:
Go to Worksheet -> Actions -> Add Action -> Filter. Over here, set it up as below: Run Action on "Select" & Clearing Selection will "Show All Values"
This will then work as follows:
You click on any Team's name (such as "A") and all other values will be hidden; then you can click on the "+" sign to expand and see the team member's names, etc. To show all values once again, just press Escape.
Attached a workbook using sample superstore data & using Product Category & Sales to show as example. You can replicate this for your Team level data then.
Let me know if you need additional help.
Filter Action - Sample.twbx 1.2 MB
My Requirement is .I have dashboad like below.When i click Any State,it should display dril values. After i have to come back again this screen. Again i have to display another state then drill down ....
State1-->City (When i see cty values i dont want to see any other than state1)
Again come back
State2-->Cty (When i see cty values i dont want to see any other than state2)
Above 2 activities should looks single chart.I dont want to go any extra chart.
Well, I cannot open your workbook due to version issues, but still here you can apply the same technique:
Make sure you have set the hierarchy = State -> City and then use this hierarchy in your view instead of State alone.
Now create the Action Filter as I mentioned before. Once you click on a State, all other states will be hidden, you selected state will enlarge in size to occupy the space, then you have to hover over the State name to locate the "+" symbol and click on it -> it will list all the cities under that State only.
Hope this is clear. Let me know if this doesn't work.
create calculated field called " Tier-2 filter"
when "A" then [Names]
when "B" then [Names]
when "C" then [Names]
when "All" then [Team]
Create another calculated field called "Drill down"
If [Team]=parameter1 then [Tier-2 filter]
Now drag Drill down filed to rows and sales to columns and use Parameter1 to drill down
Hope this helps!!