3 Replies Latest reply on Jun 1, 2016 7:36 AM by msa s

    increment in profit ration (region wise)

    nagesh koppolu

      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