You may be able to do this with a calculation that looks at the direction.
IF [Direction]='BUY' then [Volume]
ELSEIF [Direction]="SELL" then [Volume]*-1
and for the Total Price One
IF [Direction]='BUY' then [Total Price]
ELSEIF [Direction]="SELL" then [Total Price]*-1
Which would look like this:
Subtotals.twbx 18.3 KB
Everything is different when you use cube, and it's very difficult to provide hints thru forum because we cannot share the environment.
Sorry that you need to handle cube data. I have big difficulty too but no solution at all.