I have a calculated member which calculates a percentage by dividing
Measure A by measure B.
I wish to display this with other, regular, measures in a grid (we use
Proclarity professional as our front end client)with another dimension
on the rows and be able to subtotal all the measures on the bottom row.
I cannot use ProClarity's built in subtotal functionality as it will
just add up the percentages in the same way it adds up the normal
numeric measures.
I thought I would be able to create a calculated member to do the
subtotalling, using an IIF statement to pick up when the measure is the
calculated percentage and summing the rest, but cannot get it to work.
Would anyone advise what the best method would be please?
Thank you
Rachel

What value would you want to bottom row to hold for the calculated measure?

"rachel" <rachel.jones (AT) talbotuw (DOT) com> wrote

Is this what you're looking for? (Against FoodMart 2000):

WITH MEMBER [Measures].[New Measure] AS '[Measures].[Profit] /
[Measures].[Unit Sales]' MEMBER [Customers].[SubTotal] AS
'SUM({[Customers].[State Province].&[CA],[Customers].[State
Province].&[OR],[Customers].[State Province].&[WA]})'

SELECT { [Measures].[Profit], [Measures].[Unit Sales], [Measures].[New
Measure] } ON COLUMNS , { [Customers].[State Province].&[CA],
[Customers].[State Province].&[OR], [Customers].[State Province].&[WA],
[Customers].[SubTotal] } ON ROWS FROM [Sales]


"rachel" <rachel.jones (AT) talbotuw (DOT) com> wrote

Oh - the difference between this MDX and the MDX generated by ProClarity is
in the solve_order.

"Elad" <EladZZZ7690 (AT) hotZZZmail (DOT) com> wrote

Thank you for this - however, when I run this MDX in the sample
application I get an error for the subtotal - Infinite recursion
detected?
Rachel

Hi, i had this problem as well.

When Proclarity creates an automatic subtotal field, it uses a solve
order of 1000, so you need to make sure your percentage calculated
member has a higher solve order than 1000 and it should work fine.

R
rachel wrote:

I wasn't using ProClarity for this - but anyway, I see the method, so I
created a measure that added together the set & member I am using on
the rows, and it works perfectly as a subtotal, so thank you very much
for that.
Rachel