Hello, what I want to implement is a chart with 2 lines from the same measure, each has its axis because they could be very different in value. And I will have 2 filters from the same dimension, each one is for one axis line, and the user can control one or two from the filter drop down menu. Please see the sample workbook attached.
Basically in the sample, I want to show SUM(Sales) as dual axis, have 2 filters Market as 2 drop down menu, each could control 1 Sum(Sales). How could I implement this?