Difference between revisions of "XL3LookupTabular"
(→See Also) |
(→See Also) |
||
(One intermediate revision by one other user not shown) | |||
Line 15: | Line 15: | ||
| {{Code|Measure}} | | {{Code|Measure}} | ||
| Measure to calculate | | Measure to calculate | ||
+ | {{Standard_TabularColumn_List}} | ||
|} | |} | ||
Line 32: | Line 33: | ||
[[Category:Formulae]] | [[Category:Formulae]] | ||
+ | [[Category:Tabular Formulae]] |
Latest revision as of 09:55, 26 September 2013
Returns a value for a given measure for a specific filter.
Contents
[hide]Syntax
XL3LookupTabular( Connection, Measure, [Column1], [Value1],…, [Column14], [Value14] )
Parameters
Parameter | Description |
---|---|
Connection | Connection number to use |
Measure | Measure to calculate |
Column1,…, ColumnN | Name of the hierarchy that the following value applies to e.g. "Date[Year]" or "'Customer Geography'[City]" |
Value1,…, ValueN | Value for the preceding column. Can be text, numeric, date or boolean. |
Examples
Revenue 2004.
=XL3LookupTabular( 1, "Revenue", "'Date'[Year]", 2004 )
Revenue 2004, USA.
=XL3LookupTabular( 1, "Revenue", "'Date'[Year]", 2004, "'Geography'[Country]", "USA" )