• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3801
  • Last Modified:

multiple criteria in cubeset function in excel 2013

Hi I am looking to return a CUBEVALUE which includes filters on the same dimenstion twice.

The code I am using is as follows but keeps returning #N/A.  Can anyone help with where I have gone wrong in the code??

=CUBEVALUE("athenatest_athena2012 Voids","[Measures].[Stock]","[Void Entity].[Entity Desc].[Stock]","[Wdh Prop Type].[Head Name].[Residential]",CUBESET("athenatest_athena2012 Voids","{[WDH New Areas].[NPT Code].[South East NPT]","[WDH New Areas].[NPT Code].[Wakefield Rural (C) NPT]}"))

Many thanks in advance.
0
deborahhowson00
Asked:
deborahhowson00
1 Solution
 
Rgonzo1971Commented:
HI,

On the array you have the " before the { an after the }

pls try

=CUBEVALUE("athenatest_athena2012 Voids","[Measures].[Stock]","[Void Entity].[Entity Desc].[Stock]","[Wdh Prop Type].[Head Name].[Residential]",CUBESET("athenatest_athena2012 Voids",{"[WDH New Areas].[NPT Code].[South East NPT]","[WDH New Areas].[NPT Code].[Wakefield Rural (C) NPT]"}))

Regards
0
 
deborahhowson00Author Commented:
Super thanks, oh the little things... spent hours on that :(
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now