Defining Parent First Functions on Forms
You can define Parent First (PF) functions, which place the parent members above the children in forms, for the following functions:
-
DescendantsPF
-
IDescendantsPF
-
IChildrenPF
PF functions are not available as selections in the member selector in the form designer or elsewhere in the application. You can only type them in on the Layout tab of the form designer.

PF Function Examples
The following examples illustrate how PF functions display on forms:
Table 24-23 Examples of PF Functions on Forms
Function | Without PF Function | With PF Function |
---|---|---|
|
Jan, Feb, Mar, Q1, Apr, May, Jun, Q2, Jul, Aug, Sep, Q3, Oct, Nov, Dec, Q4 |
Q1, Jan, Feb, Mar, Q2, Apr, May, Jun, Q3, Jul, Aug, Sep, Q4, Oct, Nov, Dec |
|
Jan, Feb, Mar, Q1, Apr, May, Jun, Q2, Jul, Aug, Sep, Q3, Oct, Nov, Dec, Q4, YearTotal |
YearTotal, Q1, Jan, Feb, Mar, Q2, Apr, May, Jun, Q3, Jul, Aug, Sep, Q4, Oct, Nov, Dec |
|
Q1, Q2, Q3, Q4, YearTotal |
YearTotal, Q1, Q2, Q3, Q4 |
Manually Entering PF Functions
To create a PF function in the form designer:
-
Open a form for editing or create a form, and then click the Layout tab.
-
In a POV, Page, Column, or Row, find an already defined
Descendants
,IDescendants
, orIChildren
function or define one.For a full list of member relationship functions and their descriptions, see Member Relationships.
-
Manually enter
PF
directly afterDescendants
,IDescendants
, orIChildren
; for example,DescendantsPF(YearTotal)
,IDescendantsPF(YearTotal)
, orIChildrenPF(YearTotal)
. -
Click Save and then view the form. The parent members will display first in the form's hierarchy.