Hi,
I have a req to show combo chart. Bars needs to show total sales (irrespectrive of selectgion of product) . Lines needs to show sales of product (trend line on Qtr wise). so as we cant develop in one chart, i am going to create overlapping bar and line charts. But Y-axis values are changing on selection so overlapping is not fixed. i want to fix min , max and step values and that will be change dynamically based on total sales.
Dim1: year-qtr
Dim2: Product
expr: Sales
attached sample data.
Please solve this issue.