Help with calculation in analysis services

[msasnewb]

I'm looking to create a calculation in analysis services to create a ratio of a set of members against the total.

For instance, say I have a hierarchy of states. I want a measure for TARGETED_SALES which would be equal to the (total sales for (FL + GA + LA)) / Total Sales for All States.

 

[Recce]

msasnewb,

You should be able to do this calculation in SSAS. When you open the Cube there should be a tab within the Cube with the name Calculations.

You can create the calculation there and that should then form part of your measure group.

Regards

"We know nothing but, that what we know is not the truth..." - Me