...that matches text in a dimension to a numeric measure.. The syntax might look like "if Earnings_Type ="overtime" then select the value from Earnings...
Thanks in advance for any help or guidance you can provide..
Larry, how's this:
IF [Earnings_Type]='overtime' THEN [Earnings] END
If you need an aggregated one:
IF ATTR([Earnings_Type])='overtime' THEN SUM([Earnings]) END