I have a requirement to show the chart as Attached. Here Total sales is constant irrespective of the selection of Product, But when i select Product that slaes should be shown in line across the bar chart. I am choosing Combo chart with 2 exprssions
1expr: used set analysis to fix the product selection for sum(sales)
2Expr: sum(sales). it will be change based on selection of product field.
But when i select more than 2 product, it is showing sum of these product sales. but i need to show individual lines for each product.
If i get it by overlapping chart, X and Y axis values are changing automatically. so i could not fix it.
Added sample data also
Please help me on this.
Actually i have 3 fields
now i want to show total sales on bar's irrespective of product selection
and show the lines as sales of products that are selected.
so i have used below dementions and expressions are
so 1st expression shows total sales in bar's. The 2nd expression shows sales based on selection of product. but if i select 2 products then it is showing as sum of these product sales.
but i want to show different lines for each product.
I tried it by using overlapping charts one for bar and another for lines. but Y-axis values are changing .so please provide the solution to this.