Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > TopPercent() calculation to find the sum of top10% best order lin
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 7th April 04:57
ohjoo kwon
External User
 
Posts: 1
Default TopPercent() calculation to find the sum of top10% best order lin



What measure do you want to sum?

If you define a calculated member on the measures dimension and omit the
measure to sum,
the calculated member will try to sum the calculated member itself,
SumOfTop10pctInternetSalesOrder,
which causes infinite recursive computing.

Modify the formula as following;

sum(
toppercent([Internet Sales Order Details].[Internet Sales
Orders].[Order Line].Members, 10, [Measures].[Internet Sales Amount]),
[Measures].[Internet Sales Amount]
)

Also, I recommend you define named set for 'toppercent([Internet Sales Order
Details].[Internet Sales Orders].[Order Line].Members, 10,
[Measures].[Internet Sales Amount])' and reuse it.

Ohjoo
  Reply With Quote


  sponsored links


Reply


Thread Tools
Display Modes




Copyright © 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666