This is my situation in cube editor:



contry1-region11-total11
-region12-total12
-region13-total13
contry2-region21-total21
-region22-total32
contry3-region31-total31
-region32-total32

How can I create a calculated member that displays for each country the
value : sum of totals divided sum of distinct regions in that country?
For example : (total11+ total12 + total23) /3
(total21+ total22) /2



*** Sent via Developersdex http://www.developersdex.com ***

This Foodmart query should help:

with member Measures.TotalPerChild as ' (store.currentmember,[Unit Sales]) /
iif( store.currentmember.children.count
=0,1,store.currentmember.children.count) '
select
{[Measures].[Unit Sales] ,Measures.TotalPerChild } on columns,
non empty store.members on rows
from Sales

HTH,
--
Brian Altmann
BI Specialist
Huddle Group S.A (www.huddle.com.ar)
www.geocities.com/brianaltmann/olap.html


"simone damelia" wrote: