In SSAS I have deployed a cube named HCSALES.This cube has 4 measures such as:
Now I want to add a calculated member bu using my DimProduct dimension. This dimension has an attribute named ITPP. And my desired calculated member formula is like this:
SalesValue - (ITPP x UnitSold)
How can do this? Any idea?
I have tried to do it several times. I have also attached a screenshot