Calculation to use Attribute and key figure
We'd like to create a query with a calculated key figure that uses an attribute & a key figure. On 0Material we have cost as an attribute. We'd like to write a formula that uses this cost along with the net sales in the cube. Any ideas on how we would do this?
Please go through this document. It discusses how to use attribute in calculation.
Hope it helps.