How can i enable the sub total to give me the totals of
only the valid measures. In my cube, i am hiding some
measures for some security reasons. Say for example, my
measures are total records and Index.Wherever the total is
less than 25, i am hiding the Index. Since I am having
an "All" level in my dimension, I am getting sub totals,
which adds by the hidden items and then displays.

I cant remove the "All" level from the dimension.

can i have a requirement as:

if any of the measure in teh particular sub group is
hidden because of secuirty, the total should also be
displayed. If all the measures within the group are valid,
the measure against the SubTotal should be visible.

Tried hands on visual totals, but no luck..any pointers

Thanks
GS