1 Reply Latest reply on Mar 14, 2017 5:45 AM by yogi.sarumaha

    Assign Profit Margin For Category using Calculated Field

    yogi.sarumaha

      Hi

       

      Profit Margin in my case are not assigned in the database for each categories. Therefore I have to manually input them using Tableau to trace products that are good in sales and margin.
      Let's say the categories and the margins are as follows

      - Computer

      - Desk

      - Inventories

      - etc

      and the margin for each categories are as follows

      - Computer : 15% margin

      - Desk : 14% margin

      - Inventories : 16% margin

      - etc

       

      How can I assign the margin for each categories using calculated field?

       

      Thanks