Hi,
I need a way to exclude this dimension
"[Employee].[Operations Group Key].[All].[CORPSAP]"
From the below formula
=CUBEVALUE("sqlprodbi Payroll","[Employee].[Centre Key].[All].[GC - Gold Coast]","[Measures].[Mpr Completion Percentage]","[Date].[Month].[All].["&TEXT(G88,"MMM YYYY")&"]")
Thanks
I need a way to exclude this dimension
"[Employee].[Operations Group Key].[All].[CORPSAP]"
From the below formula
=CUBEVALUE("sqlprodbi Payroll","[Employee].[Centre Key].[All].[GC - Gold Coast]","[Measures].[Mpr Completion Percentage]","[Date].[Month].[All].["&TEXT(G88,"MMM YYYY")&"]")
Thanks