increment in profit ration (region wise)
I want to see changes at one time (region wise profit ratio increments) using calculated fields
created blow formula can any one help me to resolve this is this formula correct or need to change any thing. I am new to tableau tool.
correct one for single region increment.
IF ATTR([Region]) ="West" THEN [increased profit ratio] *5
ELSE [Profit Ratio correct] END
what if i want to see increment in all regions.
IF ATTR([Region]) ="West" THEN [increased profit ratio] *5
ELSEIF ATTR([Region])= "Central" THEN [increased profit ratio] *2
ELSEIF ATTR([Region])= "South" THEN [increased profit ratio] *1
ELSEIF ATTR([Region])= "North" THEN [increased profit ratio] *10
ELSE [Profit Ratio correct] END
