Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to calculate profit i need to show in pivot table. !
thanks.
Create Pivot table
Dimension= Category
Expression = Sum({<Name ={'REVENUE'}>} Value) - Sum({<Name ={'COST OF PROD'}>} Value)
Create Pivot table
Dimension= Category
Expression = Sum({<Name ={'REVENUE'}>} Value) - Sum({<Name ={'COST OF PROD'}>} Value)