How to get the no.of Items from a Pivot Field in Report Filter using VBA
<p>I used the below line to get the no.of items from a Pivot Field in a "Report Filter": <code>MsgBox pt.PageFields(5).PivotItems.Count</code> </p>

<p>But it is returning 0 everytime. I'm not sure if this is the correct way. This field for sure has Pivot Items in it. Can someone help me?</p>