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

Chart Data

Hi All

I have the following requirement.

I have data in the following format in Excel which I imported into BO as it is.

This is Sheet 1 in BO

Company Name Jan 2015 Feb 2015 Mar 2015 Apr 2015 C1 10 20 30 40 C2 50 58 39 27 C3 85 74 89 87

This is Sheet 2 in BO

Company Name Jan 2014 Feb 2014 Mar 2014

Apr 2014

C1 52 25 39 68 C2 47 58 89 74 C3 12 87 96 41

I need a bar and line combined chart that displays the above data in such a way that when I filter for any one company name I should be able to see the column chart for last year's data (Sheet 2) and this year's data (Sheet 1) in line chart in the same chart combined together split over each month. Any help would be appreciated.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Dec 08, 2015 at 06:09 PM

    In the report, I believe you will have the dimensions CompanyName1, MonthYear1 , Measure1 and CompanyName2, MonthYear2 , Measure2. You need to merge the dimension CompanyName1 and CompanyName 2 .. Similarly merge MonthYear1 and MonthYear2.

    Create a Chart with the option Combined Column Line Chart. In the Category Axis select the MonthYear merged Dimension. Add one more value Axis. Select Measure1 and Measure 2 on the Value Axis 1.

    Create a Dropdown for Company name merged dimension in the Filter bar where you can select the

    Untitled.png (33.5 kB)
    Add a comment
    10|10000 characters needed characters exceeded

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.