DE.NEXT
Returns the element in the dimension structure after a specified element.
Syntax
DE.NEXT(Database alias,Dimension,Element)
Dimension is the name of the dimension containing the element whose successor you want to determine and Element is the element.
Note: This function looks at the order of the elements within a
dimension as they were defined when creating the dimension, not the order of
the elements as they are presented by the Dimension Browser.
If an element does not exist or is not a member of Dimension, the function returns a #Value error.
Note: This function is most commonly used in conjunction with DE.FIRST
to link dynamically the elements of a dimension used in a worksheet with the
dimension elements. As the dimension changes, the report changes with it.