I am playing with OLAP cubes and connot work out the following problem:

The sales database has a field for {TransactionType} with values of "Sales" or "Returns".

However the {TransactionAmount} field stores the amount as positive regardless of whether the transaction is a sale (positive) or a return (negative).

Is there a way to overcome this?