Hi
I have been battling for some time now to understand how to change the Total calculation to only those children displayed and not hidden items as well
I am using Excel XP and AS sp3a
I have a separate SalesTarget cube that contains all my sales targets. In the sales cube i have created a measure with the following MDX
Iif(SalesPeriods.CurrentMember.Level = "(All)",
sum(SalesPeriods.CurrentMember.children,measures.c urrentmember),
LookupCube("SalesTarget",......))
Even if i change the security on the dimension "SalesPeriods" to Enable Visual Totals it still brings in the hidden values!
Where am I losing the plot?
Thanks for the help