Hello, I`m working on some reports with SSRS 2008. My database are OLAP-Cubes. The situation: The first tablix shows the number of new cases, sorted by region and - in a seperate row - the total over all regions (region as overgroup, and subregions as subgroup). The second tablix shows the number of settled cases, again sorted by region and the total over all regions. The third tablix should display the percentage of settled cases based on the number of new cases. I can manage that for the total over all regions, but if I use the same formula for the regions I can´t get SSRS to show the correct value. All I get is exactly the same figure, I already have for the total over all regions and I know that can´t be true. Is there anyone who could tell me how to get the figures for the regions? I tried to use the datasets for the tablixes of new and settled cases, but if I want to use fields of datasets which are not the special dataset for the tablix, I only can get the "sum(Fields.xy.value)" and not the "Fields.xy.value" which I need. I tried to generate a "calculated expression but I am completely new to MDX so - no surprise - that doesn´t work either. Your help would be much appreciated! NuramonTheWanderer

Ok, problem solved. I hat to persuade a data warehouse engineer to add a new meassure which contained the calculated settled-to-open-cases-ratio. Even then SSRS did it´s best to thwart any solution because apparently it cannot be kept from adding the calculated values of the subgroup to a total for the overgroup (which does not make any sense when your values are percentages and therefor not summable figures!) instead of using the value for the overgroup provided by the cube. This is rather disappointing but at least I found a workaround: In the subgroup I added a total, in which I used the aggregate-function instead of the sum-function, which must be used for the subgroup. That did the trick because SSRS no longer throws rubbish at me if asked for the values of the overgroup. For the total over all regions I used the same formula - and lo and behold: It works... NuramonTheWanderer