Getting the count of the lowest level (MDX formula) -
08-09-2004
, 03:01 AM
Hi,
I want to retrieve a count of a level.
All Region (1st level)
Asia (2nd level)
China (3rd level)
Singapore
Taiwan
Europe
Belgium
France
Spain
Italy
America
Canada
US
Depending on where i stand i want the count of the counrties. So like when i
am on belgium the count should be 1 (because this is the lowest level). When
i am on America the count should be 2 (because there are 2 countries in
America)
When i am on All Region than the count should be 9 (because there are 9
countries in total). How can i get this?
I used something like this:
Count({descendants([Region].Currentmember)})
or anything that comes close to this, but it also includes the second level
and in this case all levels, so the count is 13 .
Anyone can help me out with this?
Thnx
Stan |