Drill Down within a column chart

[Former Member]

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.

[Former Member]

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.

[antonette_venter]

Hallo Mayur

Hope this helps:

Drill down in charts tutorial

Drill down from two components

Regards

Antonette

[Former Member]

Thanks Antonette.

Appreciate your response but requirement here is first, to drill within a chart and second drill for all categories (Not for any one).

[saurabh_sonawane]

Hi

the city under the country will be changing or not in level two

[Former Member]

They may vary based on data in universe objects.

[saurabh_sonawane]

how many country are there.

[Former Member]

That too will b dynamic..

No hard coded values we have..

[saurabh_sonawane]

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

Two level drill down in SAP BO Dashboard.xlf - Google Drive