<div>
Super thanks, oh the little things... spent hours on that :(
</div>


Super thanks, oh the little things... spent hours on that :(

<div>
<div class="content wysiwyg-content">
Hi I am looking to return a CUBEVALUE which includes filters on the same dimenstion twice.<br />
<br />
The code I am using is as follows but keeps returning #N/A. &nbsp;Can anyone help with where I have gone wrong in the code??<br />
<br />
=CUBEVALUE(&quot;athenatest_ath<wbr />ena2012 Voids&quot;,&quot;[Measures].[Stock]<wbr />&quot;,&quot;[Void Entity].[Entity Desc].[Stock]&quot;,&quot;[Wdh Prop Type].[Head Name].[Residential]&quot;,CUBES<wbr />ET(&quot;athena<wbr />test_athen<wbr />a2012 Voids&quot;,&quot;{[WDH New Areas].[NPT Code].[South East NPT]&quot;,&quot;[WDH New Areas].[NPT Code].[Wakefield Rural (C) NPT]}&quot;))<br />
<br />
Many thanks in advance.
</div>
</div>


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.

multiple criteria in cubeset function in excel 2013

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.