Line Chart Issue

building reports webintelligence
1

Hi,
I need help in Line stacked chart in Webi. I am using Webi XIR3.

I need to create a line chart with two dimension and 2 Measures. Below are my objects

  1. End Date (Dimension)
  2. Product Name (Dimension)
  3. No. Of items Sold of each product (Measure)
  4. Total of all the items sold(SUM) - (Measure)

Currently I created a line stacked chart with End Date on x-axis, No. of items on y-axis and Product Name in the chart body. It gives me a nice line stacked chart but I need to add the 4th measure also. So I can have another line as a Sum of all the products.
For e.g I have 5 products but I need 6 lines in a chart and 6th one will be the sum of all the products by week. I hope I am clear enough but if not then please let me know I will try to elaborate more.

I searched a lot and I already tried using the “Veritcal Bar and line” chart as advised by others in forum but it does not give me an option to add the Product Name as a second dimension

Any help will be greatly appreciated

Thanks in Advance. :slight_smile:

Maria_2 (BOB member since 2007-01-17)

2

Any help please !!

Maria_2 (BOB member since 2007-01-17)