Hey guys. I have a PivotTable with data that looks something like this.

Collapsible: Title
. Data 1
. Data 2
. Data 3
. Data 4
Collapsible: Second Title
. Data 5
. Data 6
. Data 7
. Data 8


I need to count the number of cells with Data (so in this case, its 8). My approach to this was to count the number of cells in each collapsible row and then add them all together. However, I don't know how to count the number of cells in a collapsible row. Any help is appreciated. Thanks