GetPivotData Error in ref to Subtotal

[erock24]

Ok, I added 2 subtotals to my pivotable (min and max). When I hit = and click on one of them excel generates this:

=GETPIVOTDATA($AG$7,"Year['2016';Data,Min]")

but the formula equates to a #REF error!!.....really frustrating and annoying, what gives!!

 

[erock24]

oh, guess you have to take the word "data" out. Wow, I mean really, can we say 'bug', c'mon!!