I have a dimension "Company Owner" it has about 20 Members I would like
to create a MEMBER that shows me

Company A
Company F
Company G
Company N
Company Q

and classifies the rest into the Member "Others"

So my table would show

Company A
Company F
Company G
Company N
Company Q
Company Others

Where "Others "would be the sum of all the remaining companies

Can anyone help with this

Thanks in advance

Denver

Typically you would add another level to your dimension to handle this.
You can set the Company level not to display if the member has the same
name as it's parent, thus achieving a ragged hierarchy where only the
"Company Others" member can be expanded.

eg.

Company, CompanyGroup
Company A, Company A
Company B, Company Others
Company C, Company Others
Company D, Company Others
....
Company F, Company F
Company G, Company G
Company N, Company N
Company Q, Company Q


--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1144747459.696278.301820 (AT) e56g2000cwe (DOT) googlegroups.com>,
DenverKirrane (AT) gmail (DOT) com says...