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.