My question is based on this scenario:
1.I created a key figure as unit price, also a characteristic say material was created and I put the key figure unit price as a display attribute of material.
2.Designed a cube which includes material and key figure quantity
3.Design a query, put material into row, put quantity into column, and created a revenue by using a formula variable to calculate the revenue value(quantity*unit price), I put it into row.
The final result was: I could see the data of revenue in each row, but it didn't show me the overall result, only red 'X'. How can I solve this problem?