Created cube in AS 8.0 being viewed in Excel 2002 on XP platform.

I have a dimension with 10 values :
000,111,222,333,444,555,666,777,888,999

Created calculated member to categorize as follows:
Inpatient - 111,222,333
Outpatient - 444,555,666,777,888
Other - 000, 999

I only want to display the calculated member value (inpatient, outpatient,
other) and not the numeric values. When the dimension is pulled down into
the row field or column field section of the pivot table, both calculated and
original values appear which doubles my total results. Is there any way
(besides individual user deletion) to supress these values?

Thanks.

Have you thought about adding a new level in your dimenison rather than
using calculated members?

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

In article <D3BE6ACA-FFEF-4C63-A2CC-A8EDEEDA7A3D (AT) microsoft (DOT) com>,
Jim (AT) discussions (DOT) microsoft.com says...

Wasn't sure how I would create the new level with the substituted values.


"Jim" wrote:

The basic concept is that you would create your dimension table to look
something like the following:

Code Group
==== =====
111 Inpatient
222 Inpatient
333 Inpatient
444 Outpatient
555 Outpatient
666 Outpatient
777 Outpatient
888 Outpatient
000 Other
999 Other

....and then make one level off the code column and the level above it
off the Group column. Ideally you would use surrogate keys in order to
deal with slowly changing dimensions, but the basic concept remains the
same.

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

In article <E06E7C7C-DF7B-42E6-9261-4FEF2DC2932C (AT) microsoft (DOT) com>,
Jim (AT) discussions (DOT) microsoft.com says...