Hi Jose,

Thank you for posting in our forums.

The data sources have an ExpandExisMemberAsync method which can be used to expand all hierarchies of the grid. To do that you can use the InitializeColumn and InitializeRow events of the PivotGrid and use the following code:

FlatDataSource ds = ultraPivotGrid1.DataSource as FlatDataSource;

            // For the InitializeColumn event substitute the e.Row with e.Column

            if (e.Row.IsExpandable && e.Row.Expanded == false && ds.IsAsyncOperationPending == false)

            {

                ds.ExpandAxisTupleMemberAsync(Infragistics.Olap.AxisType.Row, e.Row.TupleIndex, e.Row.MemberIndex, true, this.ultraPivotGrid1);

            }

Please let me know if you have any additional questions.