locked
pivotselect with powerpivot RRS feed

  • Question

  • I can use this code with a regular pivot to select all the subtotals of a row field

        Set rf = pt.RowFields(1)
            ptx.PivotSelect rf.Name & "[All]", xlDataAndLabel _
                + xlFirstRow, True

    does anyone know the syntax that works with cube fields

    I have tried to record and play, but that fails.

    Thanks

    Adam


    Adam

    Friday, January 26, 2018 1:41 PM

Answers

  •  ptx.PivotSelect "'" & rf.Name & "'[All]", xlDataAndLabel _
                + xlFirstRow, True

    Adam

    • Marked as answer by AuroraMan1 Friday, January 26, 2018 2:10 PM
    Friday, January 26, 2018 2:10 PM