Hi:
I have dimensions (Owner, Product, Time) and facts (Transaction,
PriceHistory).

The transaction has a BuyQty and a SellQty, only one of which is
non-Zero in a Transaction (i.e. either a buy or a sell).

Calc Member (AquisitionCost)=
iif
(SellQty=0,
AquisitionCost.PrevMember + TranValue.CurrentMember,
UnitPrice.PrevMember * Balance.CurrentMember
)

This works fine when I have AquisitionCost in Columns, ProductCode and
Date in Rows, for all but the last row, which is the aggregate for
ProductSubCategory
where the value is zero. I would instead like it to be the last
AquisitionCost value for that Product.

How do I set this right?
Thanks a lot