Hide data of collapsed matrix group

I have a matrix with date month on the rows axis. I want to hide all
but the most recent month. The data measures I am using are not
additive so I would like to hide the data for all collapsed groups.
Is this possible? I can't figure out how to reference a report item
to see if it is hidden or not.I got it...
--code to only show values in matrix where the group is visible.
=iif(
count(Fields!Num.Value) > 1
,""
, sum( Fields!Num.Value)
)
--code to set the most recent group to visible - default
=iif(format( Fields!Date.Value,"MMM yy") = format(
First(Fields!MaxDate.Value, "MaxDateForProject") ,"MMM yy")
, false,true)

Hide Calculations for some users

Hi,

anyone know if it is possible to secure some calculated measures from different users?

I have a calculated field in the cube that I just want to show for one user.

I guess I need to write some MDX in the "Allow reading of cube content" under Edit Cell data when I edit the role.

Someone have any suggestions?

I found a solution! =)

If you want to hide the measure TB this is the code that you write in the "Allow reading of cube content" under Cell Data.

Code Snippet

Not Measures.CurrentMember IS Measures.TB

Hide Calculations for some users

Hi,

anyone know if it is possible to secure some calculated measures from different users?

I have a calculated field in the cube that I just want to show for one user.

I guess I need to write some MDX in the "Allow reading of cube content" under Edit Cell data when I edit the role.

Someone have any suggestions?

I found a solution! =)

If you want to hide the measure TB this is the code that you write in the "Allow reading of cube content" under Cell Data.

Code Snippet

Not Measures.CurrentMember IS Measures.TB

sql