Conditional Formatting based on a different measure

[zivhimmel1]

I would like to be able to format a column in a table or matrix based on values of a different measure, or based on values of the same measure in a different row of the table. Examples : 1. Conditional formatting of sales amount based on the value of sales amount last month(green if higher, red if lower etc.). 2. Conditional formatting of sales amount based on sales goal(higher/lower than goal, and how far from target)