Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

excel 2013 cubevalue between two dates

Posted on 2014-09-03
1
Medium Priority
?
404 Views
Last Modified: 2014-09-09
Hi,

I have two CUBESET dates in my spreadsheet.  One gives 'This Week' which is in cell C1 and the other gives 'Start of Year' which is in cell C3.

I am wanting to pull the 'No Voids' cubevalues between these two dates as an average over the year (average ytd basically).

This is my syntax to retrieve a basic figure based on the one date in cell C1.

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

Can anyone help with how I amend this to return the average between two dates?

Many thanks in advance.
0
Comment
Question by:deborahhowson00
1 Comment
 

Accepted Solution

by:
deborahhowson00 earned 0 total points
ID: 40311654
used a slicer
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question