Named Calculation in Analysis services

[haseebkhalid]

I have a fact table

-- State
-- District
-- AmountPerDistrict

I want to add a new calculated field to this schema which will populate the sum of AmountPerDistrict for state. i.e.

State District AmountPerDistrict StateTotal
FL A 5 12
FL B 4 12
FL C 3 12
NY X 7 10
NY Y 2 10
NY Z 1 10


The SQL query example that i tried is this

select
AmountPerDistrict,
(select sum(AmountPerDistrict) from Sales.SalesOrderDetail

where State=abc.State) as StateTotal

from Sales.SalesOrderDetail abc

Please help me achieve this scenario. Any MDX query or named calculation help would be appriciated.

Regards

[Island1]

When you use "MDX" and "named calculation" interchangeably, you're talking about two very different things.

1. Do you need to add a named calculation in the data source view?

2. Do all of the State, District and AmountPerDistrict fields already appear in the underlying data? If so, have you pulled the table / view involved into the data source view?

Get back with these specifics and I'll try to provide some guidance.

Thanks!

Bill