-
1. Re: How I get a variable within a dimension onto it's own secondary axis?
Mark Holtz Aug 28, 2012 12:16 PM (in response to joe.eckelman)It sounds like you are looking to break your prices for each Product dimension into different measures.
You could accomplish that by creating 3 calculated fields:
China HRC:
IF [Product]='China HRC Shanghai (incl...' THEN [Price] ELSE NULL END
//make the text match the value in the underlying data
FFSX:
IF [Product]='FFSX' THEN [Price] ELSE NULL END
Iron Ore Fines:
IF [Product]='Iron ore fines 58% FE / C...' THEN [Price] ELSE NULL END
//make the text match the value in the underlying data
Then, drag the MEASURE VALUES green measure pill onto the Rows shelf and filter the MEASURE NAMES to only show [China HRC] and [FFSX].
Drag the blue MEASURE NAMES pill to the Color shelf.
Then, drag [Iron Ore Fines] onto the Rows Shelf as a 2nd axis. Make sure MEASURE NAMES is also in the color shelf for this mark.
Then, you can set to non-synchronized dual axes.
-
2. Re: How I get a variable within a dimension onto it's own secondary axis?
joe.eckelman Aug 31, 2012 11:18 AM (in response to Mark Holtz)This worked well thank you!