Hi all,

My problem is finding the corrrect functions (MDX) to create the
following report;

Here are the cube details;

Dimensions: Store, Products
Measure: Total Sales

The desired output is;
Total Sales Products
------------------------------------------------
Store 1,0000 X Y Z
---------------
Downtown 500 10% 70% 20%
East-End 200 50% 15% 35%
West-End 100 30% 40% 30%
North 200 65% 5% 30%

If you have any thoughts or examples, it would be appreciated.

A query something like the following one against the Foodmart 2000
database should work.

WITH
MEMBER Measures.[Product Percent] as '([Product].CurrentMember,
[Measures].[Store Sales])/([Product].[All Products],Measures.[Store
Sales])', FORMAT_STRING ='0.0%'

SELECT
UNION({([Product].[All Products],Measures.[Store Sales])},{[Product
Family].Members} * {[Measures].[Product Percent]}) ON COLUMNS,
NON EMPTY [Store].Members ON ROWS
FROM Sales

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1137704201.086703.159350 (AT) g43g2000cwa (DOT) googlegroups.com>,
wkatwork (AT) hotmail (DOT) com says...