Microsoft Office Tutorials and References
In Depth Information
Cube Functions Introduced in Excel 2007
If pivot_tableis a range that includes two or more pivot table reports, data
is retrieved from whichever report was created in the range most recently.
If the fieldand itemarguments describe a single cell, the value of that cell
is returned, regardless of whether it is a string, a number, an error, and so
on.
If an item contains a date, the value must be expressed as a serial number
or populated by using the DATE function so that the value is retained if the
spreadsheet is opened in a different locale. For example, an item referring to
the date March 5, 2015 could be entered as 42068 or DATE(2015,3,5). Times can
be entered as decimal values or by using the TIME function.
If pivot_table is not a range in which a pivot table report is found,
GETPIVOTDATA returns #REF!. If the arguments do not describe a visible
field, or if they include a page field that is not displayed, GETPIVOTDATA
returns #REF!.
Cube Functions Introduced in Excel 2007
If you are creating pivot tables from OLAP data or from PowerPivot, Excel
offers a Convert to Formulas command. Excel uses a series of cube func-
tions to retrieve the data cells from the data source. The following func-
tions were introduced in Excel 2007.
Syntax
CUBEMEMBER(connection,member_expression[,caption])
The CUBEMEMBER() function returns a member or tuple in a cube hierarchy.
You can use it to validate that the member or tuple exists in the cube.
Syntax
CUBEMEMBERPROPERTY(connection,member_expression,property)
The CUBEMEMBERPROPERTY() function returns the value of a member prop-
erty in the cube. You can use it to validate that a member name exists within
the cube and to return the specified property for that member.
Syntax
CUBERANKEDMEMBER(connection,set_expression,rank[,caption])
Search JabSto ::




Custom Search