title: get Pivot Value (Grand Total ) using vba?
body: <p>I have a Pivot Table and I want a value from that Pivot Table which is the Grand Total value.
  If you see the below picture, I want the value "88%". This value is in cell C24 .
  And it is in the Compliance Field (Column C) and the row is the Grand Total.
  Above the Pivot Table I already have the filters applied for filtering my data. I just want the vba code for this cell/field value.
  This is what I tried.</p>
  
  <pre><code>Dim rtot as Double
  rtot = Worksheets("ABC").PivotTables("PivotTable2").PivotValueCell(3, 24).Value
  
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/yIXIn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yIXIn.png" alt="enter image description here"></a></p>