title: Get a given pivot item of the second row field given a particular pivot item in the first row field
body: <p>I have a pivot table with two embedded row labels and one data variable (see below). I would like to access the pivot item of Rowlabel2 of a given index, given a particular pivot item of Rowlabel1.</p>
  
  <p>This question (<a href="https://stackoverflow.com/questions/32916688/list-excel-pivot-items-of-the-second-row-field-multiple-row-fields-given-a-par">List excel pivot items of the second row field (multiple row fields) given a particular pivot item in the first row field</a>) is very close to my problem but not exactly what I need. I hope there exists a way to get the item without resorting to a separate sub routine.</p>
  
  <pre><code>Rowlabel1 Rowlabel2 Value
  a          A          1
             B          0
             C          3
  b          D          2
             E          8
  c          F          5
  </code></pre>
  
  <p>For instance, I would like to get the 2nd item of Rowlabel2 of the 2nd item of Rowlabel1 ("E").
  The property
      RowFields("Rowlabel2").PivotItems(2).Caption</p>
  
  <p>returns "B", not "E"</p>