I have a fact table with the following structure:
Both BuyerID and SellerID are UserID, meaning a user can be both a Buyer and a Seller. Moreover, a Buyer can sell something to himself. In this case, BuyerID and SellerID are the same.
Now this structure has been converted to a cube. I want to create an Calculation member to show the total Amount of sales of a single user. This amount should NOT include those Amount Sales that has the same BuyerID and SellerID (whatever the user sells to himself shouldn't be counted into the Total Amount of sales of the user).
How can I create this Calculation member? Thanks.