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.

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" )


See Also