Calculation of profit

[#1]

Hi,

How to calculate profit i need to show in pivot table. !

thanks.

[Kushal_Chawda · Accepted solution]

Create Pivot table

Dimension= Category

Expression = Sum({<Name ={'REVENUE'}>} Value) - Sum({<Name ={'COST OF PROD'}>} Value)