Skip to Content
Former Member
May 12, 2006 at 03:12 PM

No overall result



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?

Thanks advanced