Hi, I know that this reply is coming a good two-and-a-half weeks later. But you could try this: Set the aggregation for the measure to None instead of Sum. Then you need to setup some business intelligence by going to the Cube menu, select Add Business Intelligence. This would open up the appropriate wizard. Select the Create a custom ...

Hi Supun, Since the amount measure is indeed the aggregate of ItemAmount, why not just scrap the amount measure and use just the ItemAmount measure, since when you view order-wise data it will anyway show the ItemAmount aggregated for each Order. If you want you could also rename the ItemAmount measure as amount. Let us know how it goes...