Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3313
  • 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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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