Write an OnBeforePivot event handler to take specific action just before the information provided by the decision source changes. When OnBeforePivot occurs, the results of the pivot have been computed but not implemented. Use the GetGroup, GetIndex, GetState, GetValue, and GetRowState methods to get information about the pivot state that is about to be implemented. To get information about the pivot state that is ending, save the dimension information in an OnAfterPivot event handler. The information about the new state can then be compared to information captured the last time the pivot state was changed. The OnBeforePivot event handler can make additional alterations to the pivot state using the methods of the decision source. 

OnAfterPivot 

GetGroup 

GetIndex 

GetRowState 

GetState 

GetValue 

TDecisionPivot 

Using Decision Sources