cancel
Showing results for 
Search instead for 
Did you mean: 

Bar Chart Drill down getting "Insert in range overlaps with other series" # Error

Former Member
0 Kudos

Hi friends,

I am trying to drill down for Bar chart to Combination chart dashboard.

I have bar chart in region wise values are  Revenue ,Net contribution,Total cost ,

So when i was binding for those values for one destination column could be same

in spreadsheet  then its getting below error.

I tried formula for one destination to other columns

in spreadsheet also but that's not allowing to formula for binding destination .

Please kindly anybody help me out

Thank you

Sudhakar M

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member182541
Active Contributor
0 Kudos

I hope you are trying to overlap the destination cell for many insertion type. To be more precise on your solution can you please send me or share your mapping logic so that we can help you in better.

try to map the destination in different cells for different selection and then you can write the formula based on your logic.

Former Member
0 Kudos

Thanx  for reply suman,

Yes i am trying to destination cell for many insertion type .

Is it possible to mapping to one cell destination ?

for example : Will take A,B,C these values of Source data mapping to same data source cell

its allowing to insertion but when i am trying to mapping for same destination cell its not allowing to insertion.

any suggestion for solve this issue .

Thank you

former_member182541
Active Contributor
0 Kudos

As mentioned above its not possible to this, as workaround you can change the change the chart to drill down. Take a look at the link which have drilled down using stack column chart.

former_member190855
Active Contributor
0 Kudos

Hi Sudhakar

Map the destinations to 3 different ranges. Then use 3 history components and map their sources to the above destinations respectively and then map the destination of the History components to one single range. Set the History compoennt data insertion to When Value Changes.

Does this solve?

Runali

Former Member
0 Kudos

Hi Runali ,

Its good logic for same destination ranges    but its does'nt work runali , i tired lots of ways but getting same problem. If any thing suggetions please revert back

Thank you  

Sudhakar . M

former_member190855
Active Contributor
0 Kudos

Hi Sudhakar

What is happening when you use the History component? can you post screenshot of the data movement using spreadsheet?

Runali

Former Member
0 Kudos

Hi Runali,

Sorry for late reply,the issue was not solved .

Got another issue in BI launch pad .

one Webi report migrated from R2 environment to BO 4.1.when open that report in BI launch pad

working perfect but when report was edit in the query level and run the all queries its asking context selection

If i selected all the context and run all the queries then again getting another issue.

Why its asking Query Context in Query prompt level?

Thank you

Sudhakar M