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
and the margin for each categories are as follows
- Computer : 15% margin
- Desk : 14% margin
- Inventories : 16% margin
How can I assign the margin for each categories using calculated field?