The easiest way is just to use a field on the colour shelf, with 3 steps, as below
The other way would be to create it using a logic statement
IF SUM([sales]) < 0 THEN NULL
ELSEIF SUM([sales]) >= 0 AND SUM([sales]) < 1000000 THEN 'RED'
ELSEIF SUM([sales]) >= 1000001 AND SUM([sales]) < 10000000 THEN 'AMBER'
ELSE 'Green' END
Hope that helps, happy to provide further direction if you need
But i didn't want it on the Map. Rather on Table or any other better way of representation.
lets say I want 2 columns one column is Sales other as Cost/Profit.
Dont you think shapes is better way to represent.