I have a cube which displays information on organisations based in regions. Each region has a budget. Unfortunately when I try to sum the budget nationally I get a ridiculous figure because the regional budget figure is displayed for each organisation within that region.

What I really want to do is sum distinct values nationally which should give me the correct answer, as no 2 regional budgets are the same. I cannot find a way to do this within the cube editor.

Does anyone have any ideas???

I'm not clear on the problem -- why shouldn't the national budget be a sum
of the region budgets?

public @ the domain below
www.tomchester.net

"Michael" <anonymous (AT) discussions (DOT) microsoft.com> wrote

budget nationally I get a ridiculous figure because the regional budget
figure is displayed for each organisation within that region.
find a way to do this within the cube editor.

Because the regional budget figure will repeat for every organisation within the region. i

Region Organisation Allocation Local Budget National Budge
--------------------------------------------------------------------------------
Region A
A 10 50 21
B 20 50 21
Region
C 30 60 21
D 20 60 21

Total 80 220 210 (Use Max Here
(Should be 110

Therefore a sum of local budgets at the bottom would be too much. What I need to be able to do is sum distinct from each region, but there doesn't appear to be a way to do it

Michael

----- Tom Chester wrote: ----

I'm not clear on the problem -- why shouldn't the national budget be a su
of the region budgets

public @ the domain belo
www.tomchester.ne

"Michael" <anonymous (AT) discussions (DOT) microsoft.com> wrote in messag
news:5605CD4B-2EE5-4770-AB68-EA944A41EBFE (AT) microsoft (DOT) com..
budget nationally I get a ridiculous figure because the regional budge
figure is displayed for each organisation within that region
find a way to do this within the cube editor

It's seems a little odd. Would the total for RegionA [local budget] be 50 or
100? Would the values always be the same (50/50 210/210)? Is allocation
always fully additive?

public @ the domain below
www.tomchester.net

"Michael" <anonymous (AT) discussions (DOT) microsoft.com> wrote

appear to be a way to do it.

Because the local budget is not calculated down to individual organisation, the local budget for each organisation within a region would be the same, making the total for region A 50. Likewise the National Budget figure will always be the same, but for that particular case I can use Max to get the correct answer

----- Tom Chester wrote: ----

It's seems a little odd. Would the total for RegionA [local budget] be 50 o
100? Would the values always be the same (50/50 210/210)? Is allocatio
always fully additive

public @ the domain belo
www.tomchester.ne

"Michael" <anonymous (AT) discussions (DOT) microsoft.com> wrote in messag
news:4A341B3C-11FA-48C6-8789-DD397C448412 (AT) microsoft (DOT) com..
appear to be a way to do it