Tableau - Calculate profit when cost and revenue are in same column

Question

How can I calculate the profit when the cost and revenueon the same column

 item   account_category   balance
   x                cost         5
   x                cost         5
   x             revenue        12
   y                cost         8
   y             revenue         7

 

Answer 1

Profit:

SUM(IIF([account_category] = "revenue",[balance],NULL))
-
SUM(IIF([account_category] = "cost",[balance],NULL))

Percent of revenue:

(
    SUM(IIF([account_category] = "revenue",[balance],NULL))
    -
    SUM(IIF([account_category] = "cost",[balance],NULL))
)
/ 

SUM(IIF([account_category] = "revenue",[balance],NULL)) 

 

And follow the steps

 If you want to learn more about it Tableau, then go through this Tableau Training for more insights.