Skip to Content
Former Member
Jun 09, 2011 at 02:10 PM

How to reset drill-down column-chart based on map-chart?


Hi guys,

I'm facing pritty common issue while designing one of my dashboards. Let me describe a little bit more:

1. I have some data extracted from BW using Query as WebService into my Xcelsius spreadsheet.

2. I have map-chart - regions for some country.

3. I have a drill-down column-chart, which displays data for a selected region.

At the beginning column-chart displays results for entire country (which, in fact, is not exactly drill-down). The issue I'm fasing is, that in case I select any region and the data is drilled-down into my column-chart, I have no option to show data for the entire county in the column-chart anymore (the only one way is to restart the report).

Are there any possible way to do this, or am I doing a design error while displaying data, which is not drilled-down, into a chart which is intended to display drill-down data only?

Any help would be highly appreciated.

Thanks in advance.

Ivaylo Mutafchiev

Varna Business Services

Project Manager BOBJ