How to include multiple membes in an expression?

Hello, I'm wondering how can I include multiple members from a dimension in a Calculated Measure Expression?

Good (single member) ([ActionGroup].[ActionTag].&[147300], [Measures].[Unique Visitors])

#Value Error (multiple members)

([ActionGroup].[ActionTag].&[147300].&[107139], [Measures].[Unique Visitors])

({[ActionGroup].[ActionTag].&[147300], [ActionGroup].[ActionTag].&[107139]}, [Measures].[Unique Visitors])

Any pointer is appreciated

-Lawrence

Is this what you are looking for ?

Aggregate({[ActionGroup].[ActionTag].&[147300], [ActionGroup].[ActionTag].&[107139]} , [Measures].[Unique Visitors])

How to i apply expresion for Number format in RDL file in SQL reporting

Hi,
How do I apply Expression for number to display a more readable format in
report( like 4516785 into 4,516,785)in RDL file in SQL reporting services
i applyed " #,# " in custom format for number, it is supporting to numbers
except 0.
if the value of the number 0 then it is displaying blank value.
but i have to display 0 also.
if any body know the solution please point me .
thnaks in advance
mur.#,##0
The 0 means always show. So for instance you could also do this:
#,##0.0 which would have 1234.000 would show as 1,234.0 whereas #,##0.#
would show as 1,234
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mur" <u21134@.uwe> wrote in message news:5f28dac982c4b@.uwe...
> Hi,
> How do I apply Expression for number to display a more readable format
> in
> report( like 4516785 into 4,516,785)in RDL file in SQL reporting services
> i applyed " #,# " in custom format for number, it is supporting to
> numbers
> except 0.
> if the value of the number 0 then it is displaying blank value.
> but i have to display 0 also.
> if any body know the solution please point me .
> thnaks in advance
> mur.|||hai, Bruce Loehle-Conger
its working fine now and it help me a lot .
thank you very much for u r reply .
Bruce L-C [MVP] wrote:
>#,##0
>The 0 means always show. So for instance you could also do this:
>#,##0.0 which would have 1234.000 would show as 1,234.0 whereas #,##0.#
>would show as 1,234
>> Hi,
>> How do I apply Expression for number to display a more readable format
>[quoted text clipped - 12 lines]
>> thnaks in advance
>> mur.
--
mur
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200604/1