It'll be helpful for us if you share some sample mock up in packaged workbook.
You can using table calculation (difference), but to give the exact formula and the scope need to know how you organize your dimension in VIZ ...
1 of 1 people found this helpful
You can re-calculate your measure like this:
if last()=first() then
sum( if ([yourattribute]) = 'Confirmed' then ([measure]) else ([measure])*-1 end)
You can try re-adapting this formula!
Hope it can help!
I have changed the Calculated field. but its not coming for UnitID.
When "Gross" then Sum(
If [OrderStatus]='Cancelled' then -[CancelledSaleValue]
ELSE [Sale Value]
When "Unit" then
If [OrderStatus]='Cancelled' then -[CancelUnitID]
ELSE [Unit ID]
When "Area" then Sum(
If [OrderStatus]='Cancelled' then -[CancelSaleableArea]
ELSE [Saleable Area]
At this point I think I need a packaged workbook in order to see and better understand data and needs.