CustomHeader

Use this option to specify a custom header for a column or row. This is useful when you have a calculated column or row and want to hide the specific formula and replace it with a description, such as Variance. If you have nested dimensions in rows or columns, the custom header applies to the entire header in the row or column, not just to the dimension.

You can use a semicolon as a delimiter to specify custom headers for subsequent cells. For example, this syntax replaces the three dimension headers in the row with custom headers Scenario, Year, and Month:

R2=S#Actual.Y#2014.P#January,CustomHeader:Scenario;Year;Month

To replace some header cells but not others, use a period (.) to indicate that the original header should be displayed. You can also hide a header by leaving out the period. For example, the following syntax shows the original header for the first dimension, hides the header for the second dimension, and shows the original header for the third dimension.

R2=S#Actual.Y#2014.P#January,CustomHeader:.;;.

Caution:

When the CustomHeader option is used with calculated rows or columns, you can only set the text for the first cell of the header.

Syntax

CustomHeader:HeaderName
         

Replace HeaderName with the header to use.

Note:

You cannot use a comma (,), colon (:), or ampersand (&) in the custom header.

Example

This example sets the custom header for column 3 to Variance.

C3=Scalc(col(1)-col(2)),customheader:Variance