on 07-31-2015 10:38 AM
Hi experts,
I am trying to achieve Drill Down functionality within a Column Chart for requirement as represent below:
Level 1 having Country name as Category and Level 2 as, say, Cities.
Requirement:
In Level 2 chart, we have to display City name Country wise and also display corresponding Country name for cities under it.
(see at top of Level 2 chart)
Thanks in advance.
Mayur,
Try using a hidden combo box. Get the country that has been selected from your level 1 chart. Pass it as the label for combo make it as the selected label when chart is selected. Arrange data in such a way that combo will filter the data for the country that was selected from level 1 chart and write it in destination. Map the combo box's destination to level 2 chart. Give Ignore blank cells in series and in values. Try if it works.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
the city under the country will be changing or not in level two
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Note The below link will help you for one selection at a time, means you can select only one country at a time.
and insted of pie use a column chart
you can download the xlf of dashboard from below link
User | Count |
---|---|
86 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.