Bug! getpivotdata doesnt work when table is colapsed

[felipepinto]

On creating a pivot table i noticed that on the cells that point to a certain value (using getpivotdata) get the reference error (#REF) whenever the table is colapsed, photos follow:

pivot table expanded (focus on SUBSCRIPTION)

Get pivot cell (with expanded table):

Pivot table colapsed:

Get pivot cell (with colapsed table):

[mikekaganski]

GETPIVOTDATA help:

If the source data contains entries that are hidden by settings of the pivot table, they are ignored.

“Bug!”?

[felipepinto]

Oh well i was convinced it was a bug. that clears up, even if such behaviour was not expected.