Loop thru pivot totals?

D

Dan Ricker

PivotTable.ActiveData.Cells(<RowMember>, <ColumnMember>)
returns a PivotCell object. The PivotCell object has a
PivotAggregates Collection (one PivotAggregate for each
PivotTotal on the PivotTable. The PivotAggregate has a
Value Property that corresponds to the Value for the
Total at the Row/Column intersection for the PivotCell.

The tricky part is stepping through the Row/Column
members recursively to get the desired
PivotCell.Aggregates.

********
Depending on the users IE security settings, this is
possible.

PivotTable.Copy(Optional Selection As Object)
 
Top