prevMember

Returns the member that immediately precedes "member" in the same level. This function appears in the Sales Growth Year Over Year sample report in the GO Data Warehouse (analysis) package.

Syntax

prevMember ( member )

Example 1

prevMember ( [Outdoor Protection] )

Result

Personal Accessories

Example 2

prevMember ( [2005] )

Result

2004