Hi there

I have a Store Dimension with 15 Stores, across time. I
have two one measure, Sales and Units.

I want to calculate a "new measure" where I say, "Take
each stores sales, and work its contribution to the total
stores displayed as percentage.

Any ideas anyone.

Regards

Granville

Are you trying to calculate contribution percentage of total contribution
(profit) or just revenue?

Profit:
Store Contribution / Total Contribution = % Contribution

Revenue
Store Revenues / Total Revenues = % Revenue (this is the same calculation)


Does this answer your question?


--
Jay Nathan
MARINER
http://www.mariner-usa.com

http://www.jaynathan.com/blog


"Granville" <granville (AT) ananzi (DOT) co.za> wrote

Will the following calculated member work for you

CREATE MEMBER Sales.Measures.Contribution AS ' Measures.Sales /
(Store.CurrentMember.Parent, Measures.Sales) ', FORMAT_STRING = 'Percent'

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Yukon information at http://www.mosha.com/msolap/yukon.htm
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Granville" <granville (AT) ananzi (DOT) co.za> wrote