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?
Hi, Xi Liu
You need create 2 Parameters and calculated fields for each measure
this is the step
Create Parameter.
2 calculated fields for parameter
3. Apply the fields
Become a Viz Whiz on the Forums! Support the Community and master Tableau.