Hai expert
I would to used cubeset but after selecting first option, that mean, the cubeset only list down after the first filtering. Example as below
This meant, all items in the column New T2 will be on the list after we using the cuberankedmember
=CUBESET("ThisWorkbookDataModel","[Dim_T2_ME].[New T2].members","T2")
example like this
=CUBERANKEDMEMBER("ThisWorkbookDataModel",$P$21,4)
i try to do is as, the list of cube set only list after filtering like this
=CUBESET("ThisWorkbookDataModel",{"[Dim_T2_ME].[AOP].&[01. Human Resource & Training Related]","[Dim_T2_ME].[New T2].members"},"t",1,"[Measures].[2021 Proposed]")
result getting #n/a
anyone can give an alternative on this
thank you in advance
I would to used cubeset but after selecting first option, that mean, the cubeset only list down after the first filtering. Example as below
This meant, all items in the column New T2 will be on the list after we using the cuberankedmember
=CUBESET("ThisWorkbookDataModel","[Dim_T2_ME].[New T2].members","T2")
example like this
=CUBERANKEDMEMBER("ThisWorkbookDataModel",$P$21,4)
i try to do is as, the list of cube set only list after filtering like this
=CUBESET("ThisWorkbookDataModel",{"[Dim_T2_ME].[AOP].&[01. Human Resource & Training Related]","[Dim_T2_ME].[New T2].members"},"t",1,"[Measures].[2021 Proposed]")
result getting #n/a
anyone can give an alternative on this
thank you in advance