Ask the writing of an MDX

spidertriper

I want to implement a proportion of the report, the current report is as follows
======================================================= =====
Cost
======================================================= =====
Total cost 200
Office expenses 200
Management fee 120
Utility bill 50
Phone charge 30
Stationery fee 100
Pencil 10
Paper 80
Folder 10
======================================================= ====

I want to add the proportion to achieve the following, how do I write mdx?

======================================================= =====
Cost ratio
======================================================= =====
Total cost 300 100%
Office expenses 200 66.67%
Management fee 120 60%
Utility bill 50 25%
Phone charge 30 15%
Stationery fee 100 33.33%
Pencil 10 10%
Paper 80 80%
Folder 10 10%
======================================================= ====

水寒星

You can create a Caculate Member in the Cube design,
MDX expression:
[Measures].[Percentage] = ([measures].[Fee], [Type].[CurrentMember])/([measures].[Fee], [Type].[CurrentMember].parent)

This is using MDX statements to query.
Select SetA on Columns, SetB on Rows
From CubeName
Where [Measures].[Percentage]

#

monkeyboy923

Pay attention to the design of [cost] level.

sparta

with member [abc] as'([].currentmember, [measures].[])/([].currentmember.parent, [Measures].[]) format "%"'

yanghao314

Create Member [Measures].[Expense Ratio] AS
'([Expense Type].Currentmember, [Measures].[Expense])/([Expense Type].[ALL Expense Type], [Measures].[Expense])'