Skip to Content
author's profile photo Former Member
Former Member

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

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

pastedImage_1.png (25.8 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Sep 08, 2014 at 09:19 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

      prompt.jpg (57.7 kB)
      Query context.jpg (12.2 kB)

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.