Forum Discussion

sbkrishblr's avatar
sbkrishblr
Frequent Visitor
8 years ago
Solved

stacked chart

HI   I have Measures A & B on stacked Y axis and Measure C on Line Yaxis chart. and i have months  as X axis.   i am using stack and Line chart.   i want measure B to be sliced within based upo...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi sbkrishblr,

     

    I would do the following changes to your information:

     

    Create a calendar table

     

    Unit A table:

    1. Add Columns:
      1. Salesman - Blank
      2. Unit - "Unit A"

    Unit B Table

    1.  Add Columns:
      1. Unit - "Unit B:" & Salesman

    Append Table A with table B having a single table (Sales) with:

    1. Month
    2. Sales
    3. Salesman (for Unit A this values will be blank)
    4. Unit

    Connect the Calendar table with the Sales table and with the Target table 

     

    Make the chart with the following setup

    1. X-axis - Date from Calendar
    2. Column Series - Unit
    3. Column values - Sales
    4. Line Values - Company Target

    Final result below:

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
8 years ago

Hi sbkrishblr,

 

I would do the following changes to your information:

 

Create a calendar table

 

Unit A table:

  1. Add Columns:
    1. Salesman - Blank
    2. Unit - "Unit A"

Unit B Table

  1.  Add Columns:
    1. Unit - "Unit B:" & Salesman

Append Table A with table B having a single table (Sales) with:

  1. Month
  2. Sales
  3. Salesman (for Unit A this values will be blank)
  4. Unit

Connect the Calendar table with the Sales table and with the Target table 

 

Make the chart with the following setup

  1. X-axis - Date from Calendar
  2. Column Series - Unit
  3. Column values - Sales
  4. Line Values - Company Target

Final result below:

 

Regards,

MFelix

sbkrishblr's avatar
sbkrishblr
Frequent Visitor
8 years ago

Hi,

 

thanks for replying with your solution. we also did it exactly the same way... but when we select the filter for any of the unit B- salesman, the block gets highlighted, and rest other blocks including ( unit A block & unit B- other salesman ) gets grayed out.

 

What we want is, when we click on one unit B- Salesman ( say Unit B - Tom), then only unit B - Jack & unit B - Harry blocks should grey out, Unit A should not be grayed out.

 

Hope my point is clear.

 

thanks,

suresh K

  • MFelix's avatar
    MFelix
    Super User
    8 years ago
    Hi sbkrishblr,

    That is not possible since the seceval colours in the graph are relating only to one salesman you can' do it with a songle click only with CRTL+ click on the different values you want.

    Regards,
    MFelix