Using an Expression for Column Labels in a Custom Subject Area

You can create column labels in a custom subject area that are driven by a logical expression.

To use a logical expression for column labels in a custom subject area

1. Go to Admin - Manage Access - Custom Subject Areas.
2. Create or open a custom subject area.
3. Right-click an attribute or measure and select Edit Properties. The Element Properties dialog opens.
4. Type a logical expression in the Column Label field. For example, to create a dynamic column header that includes the prompt value of Year in a dashboard, such as "2010 Quantity", type the following:

GetPromptValue('Time.Year')+'Quantity'
5. Click Save.
6. Click Save again at the top of the page.

See Also
Creating a Custom Subject Area